Use this tool to quickly find all broken external references in your Excel sheet. Get all the found links displayed on the add-in pane, review and fix them.
How to find broken links
Open Excel table where you need to find links and run the add-in by clicking the Find Broken Links icon in the Search group on the Ablebits Tools tab:
You will see all broken links displayed in a tree view on the add-in pane:
If you want the tool to display not only broken links but all the found ones, untick the Broken links only checkbox and click the Refresh button. The broken links will be marked by a light red background:
Also, you can select the type of links to be shown by opening the drop-down list:
How to fix external references
To fix a link, right-click it on the add-in pane and select the needed action:
- You can click Change Path and set the right source directory:
- To browse for the folder with the correct linked file, pick Change Workbook or Change Sheet:
How to open source files
To open the linked file, right-click the reference on the add-in panel and select the Open Source option: