MrExcel Publishing
Your One Stop for Excel Tips & Solutions

False links. How to get rid of them?


Posted by Lieuwer on June 23, 2001 11:32 PM

My Excel application wants to update links that are not there. These links apeared after a faulty macro exported or copied a sheet out of the workbook.
Thanks to ALADIN who suggested to clean up the names in the workbook of all that has a REF reference, I got rid of two of the 3 workbooks that are linked. But one is still remaining.
There really is no link. If an empty workbook is created with the name the link asks for then there is no problem, but this workbook is in Windows\temp which is a folder which I reglary empty. Anyway I want to get rid of this false link that acts like a Ghost in my Excel application. Who can help.


Posted by lurker on June 24, 2001 7:02 PM

Get rid of the 'ghost link' by linking the workbook to itself. Say your file with the ghost link is called 'Book1.xls'. Open Book1.xls, go to Edit/Links/Change source then change the link to Book1.xls.

If that doesn't work there is an excel add-in which has been mentioned a few times on this page.
Good luck

Posted by Lieuwer on June 26, 2001 2:12 AM

Linking the sheet to itself indeed is a trick that used to wootk. However I can not use this since the link is automatic and can not be reset.

Where do I find this add-in? to solve this problem?

Lieuwer

Posted by lurker on June 27, 2001 9:51 PM

Go to: http://support.microsoft.com/support/kb/articles/Q188/4/49.ASP
If you are using Excel 2000 you may find that it doesn't work properly. Microsoft's workaround is very simple - you just have to go out and buy Excel 2002! Read about it here:
http://support.microsoft.com/support/kb/articles/Q295/9/70.ASP
Good luck