Tracing Links

S

Stephen Pain

Hi all,

I'm using Excel 97 at work, and have a large file with many sheets i
it, that claims to be linked to another spreadsheet - such that upo
opening I am asked if I would like to update links.
Is there any way of tracing where this linked cell is?

Thanks,

Stev
 
G

Gord Dibben

Stephen

Could be you have a link through a Name.

Check Insert>Name>Define to see what's there.

Alternative if no joy above..........

Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site.

http://www.oaltd.co.uk/Default.htm

With this add-in you can find and delete links if any exist.

Gord Dibben Excel MVP
 
Top