Johannes van der Pol wrote:
Is there a way to show the (full) name of links in a range of cells. I know
you can do this manually with "findlink", but am looking for a way that on
my "master print" also the name of all linked workbooks is shown.


You could write a VBA function to do it or you can use a defined name.

Insert / Name / Define / MyLinks RefersTo:=TRANSPOSE(LINKS(,1))

Then in a worksheet, select cells in a column equal in number to the number
of Excel links in the workbook and enter =MyLinks as an array formula
(Ctrl+Shift+Enter)

If you also have DDE links you can do a similar trick using LINKS(,2)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup