Use Bill Manville's free addin findlink.xla
found at Stephen Bullen's site:
http://www.bmsltd.co.uk/MVP/Default.htm
--
Regards,
Tom Ogilvy
John Baker wrote in message
...
Hi:
I have somehow got links into a spreadsheet, and want to find them and
eliminate them. I
know how to break the links, but i am also importing data intro this
spreadsheet and
somehow am bringing in a link every time I import. THe problem is I have
been unable to
locate the specific cells that are causing the linkage.
Can someone tell me of a simple way to locate the cells that contain the
linkage, so that
I can remove this irritating problem!
I have tried turing on the ability to view formulas and that has not
helped. Are there any
other tools or techniques?
Thanks
John Baker