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

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

How to manage the Find Broken Links pane

How to change the add-in's pane width

Point your mouse cursor to the border between the pane and the workbook window. The cursor will change to a double-sided arrow. Click and hold the left button of your mouse and drag the arrow to set the pane's width as you like.

How to change the add-in's pane width

How to hide/unhide the Find Broken Links pane

If you don't want to see the add-in's pane, you can minimize it to a strip by clicking the arrows in the top-right corner of the pane:

Click these arrows to hide the Find Broken Links pane

When the pane is minimized, it turns into a small vertical strip with the name of the add-in written on it:

Click the arrows to unhide the Find Broken Links pane

Click the arrows at the top of the strip to open the pane.

How to move the pane to the other side of the screen

If you want to have your Find Broken Links pane on the right, you can move it. Point your mouse cursor onto the name of the pane:

The name of the Find Broken Links pane

Click and, holding the left button of your mouse, drag and drop the pane to the icon that you'll see on the right Drag the pane to this icon

Drop the pane to this icon to move it to the other side of the screen

You can move it back to the left side the same way.

How to close Find Broken Links

To close it, simply click the Close button in the top-right corner of the Find Broken Links pane.

Close the pane by clicking on this button

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the 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
 
 
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
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