remove links

Mar 11th, 2002, 10:25 PM

HI! I want to remove a link that reffers to another excel file. although i've downloaded a utility that supposed to locate links and removes them it still exists there. I tried to change it's path to the current file but still nothing! any ideas?

Derek · Mar 11th, 2002, 11:02 PM

Hi
You could try this:
Go to Edit, Links and find the name of the link source. Use the find function on each sheet to see if it can locate anything with the sheet name (eg a reference in a formula etc).
Try removing one sheet at a time, then close/reopen file to locate the sheet/s with the link.
good luck
Derek

Dave Hawley · Mar 12th, 2002, 02:06 AM

Here some additional info (some the same)

This is a common problem with Excel and there are a few ways to fix it.

1. Go to Insert>Name>Define and make sure you do not have any named ranges refering to an outside Workbook.

2. Go to Edit>Links and try to use the "Change Source" button to refer your link back to the your open workbook. In other words try and change the link so it refers to itself.

3. Open the a new workbook and create a link to it and Save. Now go to Edit>Links and use the "Change Source" to refer the link to the new Workbook. Save again and then delete the link you created.

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

Mar 11th, 2002, 10:25 PM	#1
Guest Posts: n/a	HI! I want to remove a link that reffers to another excel file. although i've downloaded a utility that supposed to locate links and removes them it still exists there. I tried to change it's path to the current file but still nothing! any ideas?

Mar 11th, 2002, 11:02 PM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi You could try this: Go to Edit, Links and find the name of the link source. Use the find function on each sheet to see if it can locate anything with the sheet name (eg a reference in a formula etc). Try removing one sheet at a time, then close/reopen file to locate the sheet/s with the link. good luck Derek

Mar 12th, 2002, 02:06 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Here some additional info (some the same) This is a common problem with Excel and there are a few ways to fix it. 1. Go to Insert>Name>Define and make sure you do not have any named ranges refering to an outside Workbook. 2. Go to Edit>Links and try to use the "Change Source" button to refer your link back to the your open workbook. In other words try and change the link so it refers to itself. 3. Open the a new workbook and create a link to it and Save. Now go to Edit>Links and use the "Change Source" to refer the link to the new Workbook. Save again and then delete the link you created.