MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I get rid of a non-existent link?


Posted by Marion on January 25, 2002 12:50 PM

Ok.
I finally, thru the help of this message board,
got rid of some persistent code which insisted I had macros.
I copied page by page to a new workbook.

But now, my new workbook insists that I have a link to another workbook.
I don't have any links.
In fact, the file that it references no longer exists.

How do I delete a link?

Thanks.


Posted by Aladin Akyurek on January 25, 2002 1:28 PM

Marion --

Download

http://208.49.24.208/Spreads/FindLink.zip

and try it on your wb.

Another must-have is:

ASAP-Utilities at http://www.asap-utilities.com/

Both free.

Aladin

========

Posted by Stephen Hoadley on January 25, 2002 2:24 PM

try going to links in the edit menu and select change sourse and select your curent file in the browser menu

Posted by Aladin Akyurek on January 25, 2002 2:32 PM

Of course. Presumed that this was already suggested, whence the link.