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 under Ablebits Tools tab:

Find Broken Links icon

Tick the Broken only checkbox if you want the tool to display only invalid links on the pane and click the Find links in this workbook button to run the search.

How to work with the found links

You will see the searched workbook name at the top of the list, all found links are displayed in a tree view in the add-in pane.

If you don't tick the Broken only checkbox, the results will be presented in two groups: Valid Links and Broken Links.

See the name of the workbook for which the results are shown

Update the location of the linked files

You can update any level that was modified for the workbook. If the linked files are stored on a company server or your co-workers' shared disks or folders, Location will be the top tier listed for a given group of links in the add-in pane.

To change the location, click on the icon with three dots in the same line.

The location will be listed first for a given group of links

You will see a window where you can select the correct server or disk from the list. You can also right-click the location name and select the Edit option from the menu.

If location, folder, and workbook are incorrect for a link group, start updating the path and file name by clicking on the Select workbook button. You will get the Change Source: window where you can select the updated directories at once.

Select the correct folder with the linked files

If the folder with the linked file has been removed or renamed, you can set the right source directory.

Tip. If the search results indicate location, folder, and workbook for a certain group as invalid, start updating the path and file name by clicking on the Select workbook button. You will get the Change Source: window where you can select all updated file directories at once.
  1. Right-click the folder name you need to change and choose the Edit option, or click the icon with three dots in the same line. Right-click on the folder name and select the Edit option
  2. You will see the Browse For Folder window where you can select the correct directory.

Change the name of the linked workbook

Please follow these steps if you want to change the linked workbook name:

  1. Right-click the workbook name and select the Edit option from the menu, or use the icon with three dots next to the necessary entry in the list.
  2. You will see the Change Source: window where you can browse for the correct linked workbook. Correct the path and file name by clicking on the Select workbook button

Edit a linked sheet name or cell address

To edit a worksheet name or cell name, right-click on it, select the Edit option from the menu and type the correct name. Click Enter on your keyboard to save changes.

Tip. You can navigate to the referred source worksheet if you right-click the sheet name in the pane and choose the Open Source option from the menu.
Note. If you try to enter an incorrect cell address you will see the message asking you to enter a valid address.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our support forum
 

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-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
 
 
Excel add-ins and Outlook tools - Ablebits.com