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!
Jan Karel Pieterse