Quickly and easily clean up broken links
Get ALL External Links with this EASY Excel TRICK (You've NEVER seen anything like it before!)
Finding links and external references in a Microsoft Excel workbook is not as easy as you might expect. To find all workbook links, you must search through the formulas, defined names, objects, chart titles, and chart data series.
In this tutorial we explain how to quickly and easily find external links in Excel.
The first way to find external links is to search in cell formulas. For this you need to use the Excel Find function: