hyperlink
 

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

hyperlink
 

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
--
Gary''s Student - gsnu2007c


"Steve Crow" wrote:

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

hyperlink
 

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)

"Steve Crow" wrote in message
...
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