How to find broken links

  1. Open the Excel table where you need to find links and run the add-in by clicking on its icon Find Broken Links icon.
  2. Tick the Broken only checkbox if you want the tool to display only invalid links on the pane. Tick the Broken only checkbox if you want to find only invalid links
  3. Press the Find links in this workbook button to run the search. Press the Find links button to start searching

How to work with the found links

You will see the found links on the add-in pane displayed in a tree view.

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

Note. The pane will keep the search results until you close either your current linking file or the add-in pane. You will see the searched worksheet name at the top of the pane under the Broken only checkbox. It can be helpful if you need to switch between several books. See the name of the workbook for which the results are shown

Update the location of the linked files

The linked files can be stored on a company server, on your co-workers' shared disks or folders. In this case the location will be listed first for a given group of links on the add-in pane.

The location will be listed first for a given group of links
Tip. 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. Correct the path and file name by clicking on the Select workbook button You will get the Change Source: window where you can select the location, folder and workbook at once.
  1. If you need to change the location, click on the Select location button next to its name. Click on the Select location button to change the location of the linked file
  2. You will see the Find Broken Links in Excel window where you can select the correct server or disk from the list. Select the correct location from the list You can also type the location name by double-clicking on it and entering the current title. Just click Enter when you finish typing. Or you can right-click on the location name and select the Edit option from the menu. Right-click on the location name and select the Edit option

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 folder.

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. Correct the path and file name by clicking on the Select workbook button

You will get the Change Source: window where you can select the location, folder and workbook at once.

  1. Click on the Select folder button next to the folder name you need to change. Use the Select folder button to change the folder with the linked file
  2. You will see the Browse For Folder window where you can select the correct folder. Pick the correct folder You can also type the name of the correct folder by double-clicking on the line with the folder name you want to change. Click Enter to finish editing. One more way to edit the folder name is to right-click on it in the list and select the Edit option from the menu. Right-click on the folder name and select the Edit option

Change the name of the linked workbook

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

  1. Click on the Select workbook button next to its name. Set the correct file name by clicking on the Select workbook button
  2. You will see the Change Source: window where you can select the correct linked workbook. You can also type the name of the correct workbook by double-clicking on the book name and clicking Enter to confirm. Or you can right-click on the workbook name and select the Edit option from the menu. Right-click on the workbook name and select the Edit option

Edit a linked sheet name

To edit a worksheet name, double-click the necessary entry in the list and type the correct name. Then click Enter on your keyboard to save the changes.

You can also change a sheet name if you right-click on it and select the Edit option from the menu.

Right-click on the sheet name and select the Edit option
Tip. You can navigate to the referred source worksheet if you right click on the sheet name on the pane and choose the Open Source option from the menu.

Enter the correct cell address

To update the cell address, double-click on the address you want to change in the list and type the correct one. Click Enter to save the result.

One more way to edit a cell address is to right-click on it and select the Edit option from the menu.

Right-click on the cell address and choose to edit it
Note. If you try to enter an incorrect cell address you will see the message asking to enter a valid address.
Tip. You can go to the source the linking cell refers to if you right click on the cell address and choose the Open Source option from the menu. Choose the Open Source option from the menu

Featured customers

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

Please remember that we work from 8am to 4pm GMT, this is 4:00am to 12:00pm EST,
1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
40+ 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