Excel 2007 Crashed - All Hyperlinks broken

[Guest]

Can anyone please help. Excel 2007 just had to unexpectedly quit - ~It then
spent time recovering something then it came back. Unfortunately The sheet
contains many many Hyperlinks to Word and Excel files on a shared drive.

Links looked like this:
///F:\CLIENTS\BMS\BMS%20Single%20Event%20Files%202007\527%20BMS%20SEIC%20-%20MILAN\Hotel%20Booking%20Info\527%20-%20Hotel%204nights%20-%20Bullet.txt

But now like this:
C:\Documents and Settings\contract pc\Application Data\CLIENTS\BMS\BMS
Single Event Files 2007\527 BMS SEIC - MILAN\Hotel Booking Info\527 - Hotel
4nights - Bullet.txt

All the links have changed in the same way. Is there a way back???

Any help greatfully recived. Many thanks Kev.

 

[Dave Peterson]

David McRitchie has some code that you can use to change the hyperlinks:

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

And to stop it from happening again...

A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

 

[Guest]

Thanks Dave, but i have a problem finding 'Hyperlink base' In Excel 2007
File|Properties|Summary Tab|Hyperlink Base
Can you please spell this out a little - I think older versions where set
out this way?

Thanks again, Kev

 

[Dave Peterson]

Maybe someone who uses xl2007 can chime in.

Thanks Dave, but i have a problem finding 'Hyperlink base' In Excel 2007
File|Properties|Summary Tab|Hyperlink Base
Can you please spell this out a little - I think older versions where set
out this way?

Thanks again, Kev