I can't help you with preventing this from happening again, but as for how to fix it, I would write a small macro that does a 'find and replace' on the hyperlinks. If all the hyperlinks start with the same 'WorkbookABCD" string, then you can run a search for that bit of text within the complete string and remove everything before it.