Hoping someone can come to the rescue as I've recently moved a lot of my data from an external drive onto the PC hard drive.
All links from within my worksheet no longer work I've Googled but nothing seems to match what I need so I have been doing it manually (another 600 entries to go!)
It seems if I remove "..\..\..\AppData\Roaming\Microsoft\Excel\" from the existing hyperlink, then all works fine. But this is now time consuming considering the amount I have left to do.
Does anyone know a way of removing "..\..\..\AppData\Roaming\Microsoft\Excel\" from all hyperlinks within a worksheet automatically?