Links

psugrads · Apr 9th, 2002, 02:43 PM

How do you remove old links in a file when you cannot find where they exist? I've tried find/replace with the link name. I've tried search for formulas. I'm at a loss. Any help would be appreciated!!

Asala42 · Apr 9th, 2002, 02:45 PM

Hey

Try Edit-Links-Change Source. If you select your open file itself it should close the loop and kill the link (if phantom). If you get an error you likely have a Named range, formula, or chart series with an external reference.

Adam

Steve Hartman · Apr 9th, 2002, 02:46 PM

Go to Edit > Links. Click the link you want remove and click change source. Then select the file name of the file you have open and click whatever the name of the button is to close the dialog box.

You are basicly linking the data to itself which removes the errent link. Just be sure the link is actually not wanted.before you do it

ree001 · Apr 10th, 2002, 12:40 AM

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

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

Apr 9th, 2002, 02:43 PM	#1
psugrads New Member Join Date: Apr 2002 Posts: 4	How do you remove old links in a file when you cannot find where they exist? I've tried find/replace with the link name. I've tried search for formulas. I'm at a loss. Any help would be appreciated!!

Apr 9th, 2002, 02:45 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hey Try Edit-Links-Change Source. If you select your open file itself it should close the loop and kill the link (if phantom). If you get an error you likely have a Named range, formula, or chart series with an external reference. Adam

Apr 9th, 2002, 02:46 PM	#3
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Go to Edit > Links. Click the link you want remove and click change source. Then select the file name of the file you have open and click whatever the name of the button is to close the dialog box. You are basicly linking the data to itself which removes the errent link. Just be sure the link is actually not wanted.before you do it

Apr 10th, 2002, 12:40 AM	#4
ree001 New Member 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