Links to Word .docs

[google3luo359]

I create links to Word .docs in Excel.
They work for a while. Then after a few days they no longer work!

I point them to the folder where the file is:
d:\data\here

and later the link changes, on its own, to:
c:\Documents and Settings\Eric\Application Data\Microsoft\Excel\there
\book.doc !!!

Why does this happen? What's going on?

TIA

 

[Dave Peterson]

Saved from a previous post:

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

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 for this. I've never had one
of these worksheet functions change.

I'll put the path in a hidden cell (A1 in my example). (Include the trailing
backslash, too!)

Then put the filenames in A2:Axxx
Then use the =hyperlink() formula in B2:Bxx.

=hyperlink("File:////"&$a$1&a2,"Click me")
and drag down

Then when I need to change the folder, I can change it one location (A1).

I could embed the path directly in the formula:
=hyperlink("File:////c:\my documents\excel\"& a2,"Click me")
and use Edit|Replace, but that seems like more work to me.

========

If you used Insert|Hyperlink, then you've noticed that edit|replace won't touch
those hyperlink addresses.

If you used Insert|hyperlink (xl2003 menus), you'll have more work to do. But
the good news is David McRitchie has done most of it for you:

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.)

 

[google3luo359]

Saved from a previous post:

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

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

And then change the hyperlink base on the Summary tab.

Thanks very much for helping out Dave!
I tried the first suggestion (using Win XP) and so far it's holding.

I'm keeping my fingers crossed.
I'll try to update a little later down the road.

 

[google3luo359]

 Thanks very much for helping out Dave!
I tried the first suggestion (using Win XP) and so far it's holding.

I'm keeping my fingers crossed.
I'll try to update a little later down the road.

I meant to say (using xl2003, not Win XP).
Well it's been holding now for a week so I'd say we have a winner
here!

Thanks again Dave.