Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Hyperlink Recovery Problem
Was searching for this in the forum but couldn't find it. I have an excel sheet with thousands of hyperlinks on it to external files. Excel crashed due to computer freezing but that's not the problem, but when I went to autorecover, i got the excel sheet back, all the addresses had been changed to relative to my autosave location, some bug with the autorecovery program. So now i'm trying to figure out how to get all those hyperlinks to get the same root address back. Hopefully someone can help me. I've tried changing my autorecovry location to the root address i want, and then like crashing excel to get to change all the linsk back. I have excel 2003. -- duonguyen ------------------------------------------------------------------------ duonguyen's Profile: http://www.excelforum.com/member.php...o&userid=30576 View this thread: http://www.excelforum.com/showthread...hreadid=502219 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! Hyperlink Recovery Problem
Take a look at David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm look for: Fix Hyperlinks (#FixHyperlinks) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm duonguyen wrote: Was searching for this in the forum but couldn't find it. I have an excel sheet with thousands of hyperlinks on it to external files. Excel crashed due to computer freezing but that's not the problem, but when I went to autorecover, i got the excel sheet back, all the addresses had been changed to relative to my autosave location, some bug with the autorecovery program. So now i'm trying to figure out how to get all those hyperlinks to get the same root address back. Hopefully someone can help me. I've tried changing my autorecovry location to the root address i want, and then like crashing excel to get to change all the linsk back. I have excel 2003. -- duonguyen ------------------------------------------------------------------------ duonguyen's Profile: http://www.excelforum.com/member.php...o&userid=30576 View this thread: http://www.excelforum.com/showthread...hreadid=502219 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing csv files, problem with date formats | Excel Worksheet Functions | |||
hyperlink problem | Excel Discussion (Misc queries) | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
Hyperlink to a word document | Excel Discussion (Misc queries) |