- Open the Excel table where you need to find links and run the add-in by clicking on its icon .
- Tick the Broken only checkbox if you want the tool to display only invalid links on the pane.
- Press the Find links button to run the search.
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.
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.
- If you need to change the location, click on the Select location button next to its name.
- You will see the Find Broken Links in Excel window where you can select the correct server or disk 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.
If the folder with the linked file has been removed or renamed, you can set the right source folder.
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 the location, folder and workbook at once.
- Click on the Select folder button next to the folder name you need to change.
- You will see the Browse For Folder window where you can select 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.
Please follow these steps if you want to change the linked workbook name:
- Click on the Select workbook button next to its name.
- 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.
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.
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.
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.
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 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:
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 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:
Click and, holding the left button of your mouse, drag and drop the pane to the icon that you'll see on the right
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.
- ABOUT US