Where is the file ?

[Ty]

Does anyone know if there is a way to tell when you open
a spreadsheet what files it is linking to (other excel
spreadsheets)?

Thanks.

Ty

 

[Jim Rech]

Use Edit, Links to find the workbooks the active workbook is dependent on.

 

[Ty]

Jim - sorry one more question - it shows me the links how
can I cut off one of the links as it is no longer needed ?

Thanks.

Ty

 

[Frank Kabel]

Hi
you may have a look at the following tool:
http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=FindLink.zip