Tracing Links

[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

 

[Frank Stone]

hi
on the toolbar try edit>links
regards
Frank

 

[Guest]

Hi
for an addin see:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

 

[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