Hyperlink

[Mhelsky]

Multiple links has been changed to different path. I don't know what
happened. I'd been using this eversince and able to open all the linked file,
but now it suddenly can't open to the specified file, the new path has been
changed to c:\documents and settings\..... How can I restore the old
destination without editing the hyperlink one by one? Even I wanted to move
it to the specified folder, I can't coz I'm not the administrator of my pc.
It's really a nightmare as it's been done since 2007.

Please, I would greatly appreciate your response.

Thank you.

 

[Dave Peterson]

A few people have said that this has stopped the problem from reoccurring.

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

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.



I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.xxx","Click me")

==============
If you have to change lots and lots and lots back...

You could use the code from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)