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