Finding and removing links

ad5184 · Apr 9th, 2002, 06:27 PM

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.

Tom Schreiner · Apr 9th, 2002, 06:43 PM

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

Asala42 · Apr 9th, 2002, 06:43 PM

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 · Apr 10th, 2002, 04:42 AM

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

ad5184 · Apr 10th, 2002, 11:22 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 06:27 PM	#1
ad5184 Join Date: Apr 2002 Posts: 13	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.

Apr 9th, 2002, 06:43 PM	#2
Tom Schreiner Join Date: Mar 2002 Posts: 6,680	Might want to try CNTRL/~ to view all formulas??? Tom

Apr 9th, 2002, 06:43 PM	#3
Asala42 Join Date: Feb 2002 Location: Tampa, FL USA Posts: 886	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

Apr 10th, 2002, 04:42 AM	#4
ree001 Join Date: Apr 2002 Location: Netherlands Posts: 6	I had a similar problem, Tom Urtis gave me this link http://support.microsoft.com/default...;EN-US;q188449 worked for me

Apr 10th, 2002, 11:22 AM	#5
ad5184 Join Date: Apr 2002 Posts: 13	I found some named ranges and deleted them so thanks for the tip.