Archive of Mr Excel Message Board


Back to Links in Excel archive index
Back to archive home

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?

Re: Getting rid of automatic 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


Re: Getting rid of automatic links

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.