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 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.