excel hyperlink not working



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


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

If this post helps click Yes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question