hyperlink

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Crow - 27 Jan 2008 06:48 GMT

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

Reply to this Message

Gary''s Student - 27 Jan 2008 12:05 GMT

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

Signature

Gary''s Student - gsnu2007c

> 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.
[quoted text clipped - 4 lines]
> Thanks
> Steve

Reply to this Message

Ron Coderre - 27 Jan 2008 13:08 GMT

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)

>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
[quoted text clipped - 3 lines]
> Thanks
> Steve

Reply to this Message