How to find broken links in Excel

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:
Run Find Broken Links.
You will see all the found links displayed in a tree view on the add-in pane:
Find valid and invalid external links.
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:
Fix external broken links, edit the path, change book or worksheet.

  • You can click Change Path and set the right source directory:
    Change path and find the correct file.
  • To browse for the folder with the correct linked file, pick Change Workbook or Change Sheet:
    Change worksheet or workbook to correct a reference.

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:
Open the linked file.

Responses

Thank you!

Reply

Post a comment

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.