PPRuNe Forums - View Single Post - Excel hyperlink file paths changed after IT 'upgrade'
Old 18th Apr 2019, 08:30
  #4 (permalink)  
Jhieminga
 
Join Date: Mar 2002
Location: near an airplane
Posts: 2,764
Received 46 Likes on 37 Posts
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.
Jhieminga is offline