Finding/deleting old links?

[johnnyrad]

Hi,

I've got a workbook with about 5 links somewhere on one of th
sheets... im not sure where. When I go to Edit/Links I can see th
links and what they are linking too (all old stuff that we do not us
anymore). I just want to delete these links. Is there a way to fin
out where the links are in the workbook and go there to delete them

 

[SkyDiver]

You can select all sheets and search for part of the path, "C:\Excel\".

If that doesn't find them, look in your Named Ranges. Those can refe
to other files as well. Macro buttons and other non-data objects ca
also reference other worksheets.

Finally, I use a product called Link Finder, www.add-ins.com, which ca
search for links and value them out if you want it to.
-- Georg

 

[Frank Kabel]

Hi
try the following add-in to find/delete these links:
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip