MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting Rid of Broken Links

December 07, 2001 - by Bill Jelen

How can I get rid of broken links after receiving an e-mailed workbook?

There are many causes of broken links. A great place to start to look is in the Insert - Names - Define dialog box. Many named ranges may be pointing to the linked workbook. Simply delete these unused names. Another place that links may hide is in the Data - Consolidate dialog box. If you use Data Consolidate, you may find old entries hanging out in this dialog box may be the source of the unwanted link.