I recently upgraded an end users' laptop to one that now has Windows 7. I copied all of his data to a backup drive and restored it into his new My Documents folder.
However, within the spreadsheets, he has local hyperlinks that pointed to a folder on his computer. So rather than point from Documents and Settings/jsmith/my docs/foobar/myfile1.pdf
, it is going to a obscure directory.
He has far too many of these files to manually update them. Is there a macro or an easier way to update all the links? The pattern I think shouldn't be an issue, but we have really no idea how to fix this easily
The Macro in How to find and replace link paths in multiple Excel files at once did not work. These are local files, not websites. They are pointing to PDFs as mentioned above.
The HTML conversion is causing issues too.
If you go to edit hyperlink manually, it shows up as:
..\AppData\Roaming\Microsoft\Excel\foobar\foo%20bar\AA11111%20Foo%20Bar.pdf
Why?
PowerGREP also did not work.