Finding and removing links

[ad5184]

I need to find out how to find links within my sheets and erase them. So far I have had no luck at actually finding the data that is linked.

 

[Legacy 98055]

Might want to try CNTRL/~ to view all formulas???
Tom

 

[Asala42]

hiya,

Things to check:

1. Did the file not have links earlier, then possibly after copying have the links? Might be phantom links. If not move to (2), otherwise do an editlinkschange source and select the file itself.

2. Formulation in your sheets. An easy way to search is to go to Tools-Options-View and check "view formulas" so you can scan for links. If you only have that one file open, links really stand out (instead of ='[Book1]Sheet1!A1 you'd see 'C:My Documents...!A1).

3. Do you have any named ranges? Check InsertNameDefine - you may have named ranges that have source data to another file. you can tweak the source data or delete the offending named range from there.

4. Any Charts? Check each data series in your charts to see references to other files.

Good luck,
Adam

 

[ree001]

I had a similar problem, Tom Urtis gave me this link
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q188449
worked for me

 

[ad5184]

I found some named ranges and deleted them so thanks for the tip.