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.

Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.