Prev: Pivot Table Calculated Field - Sum/count
Next: How to XML Map Repeating Rows?
From: Kera on 12 Nov 2009 11:33
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...
From: Jacob Skaria on 12 Nov 2009 11:49
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
---------------
Jacob Skaria


"Kera" wrote:

> 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...
 | 
Pages: 1
Prev: Pivot Table Calculated Field - Sum/count
Next: How to XML Map Repeating Rows?