Wednesday, December 01, 2004

Broken Links in Excel

If you have ever opened a workbook that has broken links then you will know how frustrating it can be to clear them.

There are a number of ways you can do this.
If the missing workbook has had its name or directory structure changes then you can simply update the links by going to Edit Links and then for each work book listed. This will only work if it is exactly the same as the previous linked workbook.

If the links are to a file you no longer want to link to then you can remove them.
Using the Edit Links dialog box you can find the names of the files. These can be found using the Find function, and then can be deleted.

Sometimes these methods still don't work and you still have links left.
Two tips.
First of all make sure there are no hidden sheets. There may be links on hidden sheets.
Second look for named ranges that refer to another file. USe CTRL F3 to open the named ranges list and check for names that have another file name in the reference. Delete (or re-reference) these.


Posted by: Jethro | 6:59 PM |