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.
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 the found links displayed in a tree view on the add-in pane:
If you want the tool to display only invalid links on the pane, tick the Broken links only checkbox and click the Refresh button.
If you don't tick the Broken links only checkbox, you will see all the found external links. The broken ones will be marked by a light red background and a special icon near the cell's address.
To fix a link, right-click it on the add-in pane and select the needed action:
To open the linked file, right-click the reference on the add-in panel and select the Open Source option:
I just got this installed. I am working on spreadsheet that is nothing but hyperlinks that lead to a pdf file. When I try to look for broken links, it states, "There are no references to Other files in this worksheet." Any help is appreciated.
Hello Inge,
Thank you for contacting us.
Our Find Broken Links checks the links to other Excel sheets and cells only, hyperlinks are not supported in the current version of the add-in.
