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 broken links displayed in a tree view on the add-in pane:
Find valid and invalid external links.
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:
Find all links.
Also, you can select the type of links to be shown by opening the drop-down list:
Find all links.

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

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.

Reply

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.

Reply

Ask a question (posted publicly)

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.

Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard