hyperlink

[Steve Crow]

I am running excel 2002 on windows xp professional. I have an excel
file and I am trying to create a hyperlink to a file on the network.
After I create the hyperlink I can click on it and it will open the
file. After I save the excel file it will not work any more. Any
suggestions.

Thanks
Steve

 

[Gary''s Student]

Assume you have assigned a Mapped Drive to the server location, say G:

Put the name of the file somewhere, say E45:
dental options.xls

In another cell:
=HYPERLINK("file:///G:\" & E45)

this will get you a nice stable hyperlink

 

[Ron Coderre]

Are you using the Universal Naming Convention (UNC) to refer to the
file...or are you using a mapped drive letter? I haven't experience any
issues using the UNC.

Examples:
Using UNC:
\\MyServer\MyFolder\MyFile.xls

Using a mapped drive letter referring to \\MyServer\MyFolder\:
H:\MyFile.xls

You might notice that your browser or newsreader interprets the UNC version
as a link, but not the mapped drive version, above.

Does that help?
--------------------------

Regards,

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