MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting rid of automatic links


Posted by A.R. on December 12, 2001 8:11 AM

When I open an Excel file, a dialogue box comes up saying if I want to update linked information. I must have accidentally activating updated links. How do I delete updated links?


Posted by Chris D on December 12, 2001 11:51 AM

You probably need to find them first........

Try right clicking on a sheet tab, then "select all sheets", this will highlight all sheets in the spreadsheet, then go up to "edit" and select "find" and type in ".xls]" making sure it is "looking in" formulas.....

as a formula link to an external spreadsheet will always be in the format : =+[name.xls]Sheetname!cellreference, it will be looking for the .xls] bit

However, if there's hundreds of links (entirely likely) you may be better off with some VBA code to automate it.... not my forte at the moment : any ideas anyone ?

HTH
Chris D

Posted by Bariloche on December 12, 2001 7:50 PM

A.R.,

If the manual method doesn't work, you can check out this add-in available from MSFT called "Dellinks":

http://support.microsoft.com/support/kb/articles/Q188/4/49.asp


I've used it. I sure beats trying to hunt them down. And why create code when a free add-in already exists. :-)

enjoy