I have a spreadsheet that was recovered and now has 100s of broken hyperlinks. The address is now going to a local C:\ drive, instead of a shared network drive. Is there a way I can repair, without going into each individual hyperlink? They are all to different pdf docs, but are within a same folder/subfolders. I have tried to create a macro to edit the hyperlink and change the incorrect portion of the address. This works one time, but does not run and make other changes needed?
Ex: C:\Temp\Dollar MTR's - Do NOT DELETE\231355\A218.pdf
needs to be change to
Z:\Common\Fab\Inventory\Dollar MTR's - Do NOT DELETE\231355\A218.pdf