A frequent problem with Excel workbooks is links that cannot be found because e.g. the folder structure on the server has changed.

I’ve been working on a utility to fix broken links very recently.
This utility enables you to search for missing links and/or find and replace strings in their paths.

This is a screenshot of the tool:

I have just published the first Beta here:

Open the utility, then open your file with broken links, then select tools, fix broken links.

Remember: this is a beta, so make a backup copy first!

Enjoy,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com