Links

mario · May 8th, 2002, 07:36 AM

How can I sever a link between two files so that I am not asked every time if I want to update the workbook I am opening up? Thanks.

Tom Urtis · May 8th, 2002, 07:58 AM

If you know where the link is, simply copy and paste special value over it, to make it a hard number. Or, you can enter a formula into that cell that refers to a cell or range of cells within that same workbook.

If you don't know where the links are, here are a few tips to locate them, repeated from the many previous posts on this board regarding the topic of phantom links:

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.

One neat tip posted by a user whose name I cannot remember, is to do an Edit Find search for *=*[* specifying Formulas in the Look in field.

Again, credit goes to the posters on this board for these ideas, and I bet there are some other clever tricks out there for this links issue.

Also, see this link to Microsoft about links:

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

Good luck.

Ricky Morris · May 8th, 2002, 10:26 AM

I have created a utility that will remove Excel links from a file. Let me know if you're interested and I'll send it to you.

May 8th, 2002, 07:58 AM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,387	If you know where the link is, simply copy and paste special value over it, to make it a hard number. Or, you can enter a formula into that cell that refers to a cell or range of cells within that same workbook. If you don't know where the links are, here are a few tips to locate them, repeated from the many previous posts on this board regarding the topic of phantom links: 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. One neat tip posted by a user whose name I cannot remember, is to do an Edit Find search for =[* specifying Formulas in the Look in field. Again, credit goes to the posters on this board for these ideas, and I bet there are some other clever tricks out there for this links issue. Also, see this link to Microsoft about links: http://support.microsoft.com/support...SRCH&SPR=XLW97 Good luck. __________________ Tom Urtis Microsoft MVP - Excel

May 8th, 2002, 10:26 AM	#3
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	I have created a utility that will remove Excel links from a file. Let me know if you're interested and I'll send it to you. __________________ It's never too late to learn something new. Ricky

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

May 8th, 2002, 07:36 AM	#1
mario New Member Join Date: Apr 2002 Posts: 5	How can I sever a link between two files so that I am not asked every time if I want to update the workbook I am opening up? Thanks.