Excel hyperlink file paths changed after IT 'upgrade'
Gone round in circles trying to recover this, rather than manually correct a few hundred hyperlinks in an excel workbook.
I saved an excel workbook last night and then, on logging into a company laptop this morning, I had a mandatory software upgrade. After that, most of my hyperlinks had a new path added e.g. changed from Workbook%20One.xlsm#'Index 2'!A1 to ..\..\AppData\Roaming\Microsoft\Excel\Workbook%20One.xlsm#'I ndex 2'!A1
Which means that they don't work. I've tried a couple of macros I found and Kutools for Excel. Didn't work. Our IT support were useless.
Any fixes and how can I prevent this happening again?