MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I delete a link?


Posted by Gerhard on November 08, 2001 4:30 PM

Hello:

My spreadsheet has a link to a file that no longer exists, and I can't even find reference to it in any cells, but the spreadsheet still looks for it. How can I delete that link?

Thanks,
-Gerhard


Posted by bob umlas on November 08, 2001 4:42 PM

send me your email & I'll send you a workbook which finds/deletes phantom links.
use bobumlas@yahoo.com or rumlas@kpmg.com

Posted by Gerhard on November 14, 2001 11:28 AM

Thanks Bob.

Also, for anyone else who runs into this problem, see "Breaking a Link" by Susan posted 11/09/01; this refers you to a page by Microsoft to add in the Delete Links Wizard to your Excel.

http://support.microsoft.com/support/kb/articles/Q188/4/49.ASP?LN=EN-US&SD=gn&FR=0&qry=dellinks&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97

Thanks again,
-Gerhard