MrExcel Publishing
Your One Stop for Excel Tips & Solutions

LINK UPDATE PROBLEM


Posted by Sandi F on April 15, 2001 4:23 PM

Okay, not sure how to word this but here goes. I created a file with links to a couple other files. I deleted 2 of them and now when I open it, I get a message telling me "File not found." I can't seem to delete these links and they are driving me crazy!! Please help!


Posted by Jacob Hilderbrand on April 15, 2001 4:34 PM

The function where this code is wherever it is will have the name of the workbook that it is referincing. So for example when you open if it says cannot find file (myfile.xls) then you should do a find for that. Then delete or modify the code to elliminate the problem.

Hope this helps.

Jacob

Posted by Sandi F on April 15, 2001 4:39 PM

I already deleted the files, that is why the error message is occuring....


Posted by Dave Hawley on April 15, 2001 5:49 PM


Hi Sandy

This is a relatively common problem in Excel.
I have written the full documentation
on how to go about removing links, but I'm unable to access it for another 10 hours.

But go here:
http://support.microsoft.com/support/kb/articles/q188/4/49.asp

and download the Delete links wizard. If you still having problems you can email me.

Dave
OzGrid Business Applications

Posted by Dave Hawley on April 15, 2001 8:16 PM

Found it!

Hi Sandy

I have my links documentation in a previously asked question, so here it is:


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/kb/articles/Q188/4/49.ASP?LN=EN-US&SD=gn&FR=0&qry=delete%20links&rnk=1&src=DHCS_MSPSS_gn_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

Dave


OzGrid Business Applications

Posted by Sandi F on April 17, 2001 1:05 PM

Re: Found it!


Okay, I have the download, but I am not sure on how to use it!!