Fixing broken links
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
Rob van Gelder:
Hi JK:
Is this utility at all like Bill Maville’s FindLink add-in?
I used that add-in the other day and it didn’t catch one link. Where a button is assigned a macro in a different workbook.
Nice idea.
Cheers,
2 April 2006, 3:57 pmRob
jkpieterse:
No, it complements it though. Bill’s excellent FindLink finds links in a workbook and tells you where exactly they are located. You can use it to break links too, controlling exactly which instances you replace with their values.
This utility operates on the links as they are shown in the Edit/link dialog and enables you to automatically search for the ones that are not available in their current location.
2 April 2006, 11:53 pmjkpieterse:
Hi All,
Just a head’s up to tell you I have updated the utility. Same download link as in the post.
Regards,
Jan Karel Pieterse
4 April 2006, 9:16 amwww.jkp-ads.com
jkpieterse:
Hi All,
I have updated this utility again.
Regards,
Jan Karel Pieterse
26 April 2006, 8:30 amwww.jkp-ads.com
lepm:
We had the same problem, but used a great utility software program called LinkFixerPlus. It allowed us to automatically fix broken links in files after we moved them from one server to another and after the folder structure changed. It may be a good solution for your needs.
13 May 2008, 2:44 pm