How do I find and break links?

[Guest]

I have a large spreadsheet. When I go to Edit/Links, it says I have links to two other spreadsheets on my C drive. I've done a Find for the filenames and they don't turn up in any of the tabs. Nothing ending in XLS.

Is there a way to find which formulas contain the links? Could something besides formulas be linked? I want to get rid of the links.

 

[lenze]

Check to see if you have any Named Ranges linked to other Workbooks

 

[Jack in the UK]

Hi --

Common question.. can i suggest search links and these bundels there. Check out my pal Chris Davidson, he love links and has a way arrond this, find him in memebers.. about assigning links to dummy link delete... very cleaver.

 

[NateO]

A quick way to look at your formulae is by hitting your ctrl key and ~ at the same time. Links also tend to build up in the name ranges. Go to insert->names->define... and if you have names, just highlight them and see what they're referring to.

Also, these guys say they have a program to delete the links, haven't tried it, but here's the link:

http://www.erlandsendata.no/english/vba/ws/findlinks.htm

Hope this helps.

Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>
This message was edited by NateO on 2002-03-14 15:39

 

[RaoulF]

NateO

I was trying to get rid of some similarly ghostly links, so I followed your "Ctrl+~" advice in one of the sheets of my workbook. It didn't appear to do anything at all, but somehow the links problem has stopped popping up! How did this fix my problem??

Thanks BTW!!