Finding/deleting old links?

J

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
 
S

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
 
Top