Disable automatic link

AllenL · Apr 9th, 2002, 06:35 AM

Hello
I have a workbook and everytime I open it; I get an automatic link to another workbook message. How can I disable the message or disable the automatic link?
Thanks in advance

Dave Hawley · Apr 9th, 2002, 06:46 AM

Hi Allen

I am assumming you have phantom links? If so this should help

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.

.....If all the above fail, microsoft have seen this as a problem and have a free download here:

http://support.microsoft.com/support...SRCH&SPR=XLW97

In fact it is a handy add-in to have even if one of the above steps does work.

Hope this helps

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

Apr 9th, 2002, 06:35 AM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Hello I have a workbook and everytime I open it; I get an automatic link to another workbook message. How can I disable the message or disable the automatic link? Thanks in advance

Apr 9th, 2002, 06:46 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Allen I am assumming you have phantom links? If so this should help 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. .....If all the above fail, microsoft have seen this as a problem and have a free download here: http://support.microsoft.com/support...SRCH&SPR=XLW97 In fact it is a handy add-in to have even if one of the above steps does work. Hope this helps