Hello
I use an Excel 2003 sheet with about 400 hyperlinks which point to web archive files (.mht) saved in a nearby folder. On the sheet, these links are denoted by a clickable "x" rather than the entire path of the .mht. Excel crashed recently, and when I saved an auto-recovered copy, I found that all the hyperlinks were changed, rendering them useless. I get a message saying "Cannot open the specified file".
The original path was file:///C:\folder1\folder2\folder3\folder4\FOLDER5\name of .mht
The modified path is: file:///C:\Documents and Settings\owner\Application Data\Microsoft\Excel\FOLDER5\name of .mht.
"FOLDER5," and of course all the .mhts, do not exist in the modified path. In the original path, I had "folder4" name "Excel". Did this confuse the auto-recovery program, causing it to point to the wrong Excel folder?
The thought of manually fixing all 400 links is unpleasant. Is there a way to globally modify all these hyperlinks back to their original state?
Thanks for any help.
I use an Excel 2003 sheet with about 400 hyperlinks which point to web archive files (.mht) saved in a nearby folder. On the sheet, these links are denoted by a clickable "x" rather than the entire path of the .mht. Excel crashed recently, and when I saved an auto-recovered copy, I found that all the hyperlinks were changed, rendering them useless. I get a message saying "Cannot open the specified file".
The original path was file:///C:\folder1\folder2\folder3\folder4\FOLDER5\name of .mht
The modified path is: file:///C:\Documents and Settings\owner\Application Data\Microsoft\Excel\FOLDER5\name of .mht.
"FOLDER5," and of course all the .mhts, do not exist in the modified path. In the original path, I had "folder4" name "Excel". Did this confuse the auto-recovery program, causing it to point to the wrong Excel folder?
The thought of manually fixing all 400 links is unpleasant. Is there a way to globally modify all these hyperlinks back to their original state?
Thanks for any help.
Last edited: