excel hyperlink not working

[Kera]

A co-worker is trying to create hyperlinks in different cells which link to
files in a shared network directory. When he sends the files out, no one can
access the links, they refer to a local directory (ie: file:///C:\Documents
and Settings\ - and so on) However when you look at the formula bar, the
correct file path is diaplayed.

I took the file and created a link to the SAME files he was and emailed it,
and it worked, people were able to access the hyperlinks. What are we doing
different? I walked him through my exact steps...

 

[Jacob Skaria]

Take a look at the help for the worksheet function

=hyperlink()

'Use the UNC Path
=HYPERLINK("\\servername\sharename\folder\file.extension","Click me")

If this post helps click Yes