Hyperlinks Broken after saving.

[Stever]

We have an Excel 2003 spreadsheet with one column that has a series of
hyperlinks to a network drive that is on a different server than the one the
spreadsheet is on. After creating the hyperlinks. we are able to use them
and all is well. As soon as we save the document the links no longer work
eventhough we haven't closed the document. If we create hyperlinks to a
folder on the same server as the spreadsheet we can save the document and it
all works fine.

Any ideas?

Thanks

Steve

 

[Ron Coderre]

What do the hyperlinked references look like?
Can you post an example?

Do they refer to mapped drives (z:\Folder\myfile.xls)
or did you use the UNC (\\server\Folder\myfile.xls) so they work on any
networked PC?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Stever]

We are creating the hyperlink using a mapped drive but the resulting
Hyperlink creates a UNC \\DellNas\Utility\Database The Hyperlinks are to
folders not a specific file.

 

[Dave Peterson]

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)

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

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

 

[Bob I]

Tools, Options, General, Web Options, Files, UNcheck "Update links on save"

 

[Stever]

Thanks for the responses!

This was the suggestion that fixed it and doesn't require a change on each
of the desktops.

 

[stevesentas]

Yep, thanks Bob!

your instructions fixed it. The other guys I work with don't have this
problem with "update links on save" being checked, so it must be the
way my PC is configured to connect to the network drive.