Hyperlinks in Excel are randomly changing

[דביר]

Hi ,
We have an excel 2003 file which we use to index word 2003 documents at the
company.
Lately there is a problem the the hyperlinks in excel changing :
before - file:///\\file server\share\library\word.doc
after - file:///c:\document and settings\username\local settings\temporary
internet files\word.doc

only one user have write permission's on that server directory all other
have read only permission's.

help plz

 

[Dave Peterson]

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

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, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If it's just a few, I'd do it manually.)