Finding file references within cells

[Chris]

Hi,

I'm currently using Excel 2003 and create a variety of spreadsheets that
link between tabs and files. What inevitably happens is that I lose track in
a complex sheet of which cells link between files. I know you can go to Edit
--> Links to show the files that are linked and I know you can use the audit
function to find references within a sheet, but is there a way to find out
which cells in a sheet are linked to other files?

Thanks in advance!

 

[Sean Timmons]

Just use your find.

Get the file name you are looking for, then find this name and use Find All.
This will list all cells with that file name.

 

[Chris]

Hi Sean,

Thank you thank you thank you!

Just use your find.

Get the file name you are looking for, then find this name and use Find All.
This will list all cells with that file name.