location of a link in server

[Lowan Chan]

Hi,

I have an excel file saved at server. I am trying to link some photo files
which are also saved at the same server. But everytime after I save the
excel file, the linking address automatically change to a location in C:\.
How can I do to maintain the correct location in server?

Thanks in advance.

 

[Jacob Skaria]

Check out help on worksheetfunction HYPERLINK() and mention the UNC path
(Universal Naming Convention ) of the file.

=HYPERLINK("\\servername\sharefolder\book11.txt")

If this post helps click Yes

 

[Lowan Chan]

Hi Jacob,

I tried, but it doesn't work. I would like to make it specific:

I want to link Excel file "Order" cell D1 with a subfolder "ABC Company"
under server F. there is an other subfolder "Sales" between "ABC company"
and server F. So, when i click D1, I can goes to "ABC Company" folder
directly. so I write:

=hyperlink("\\F:\Sales\ABC Company")

Can you help where goes wrong? Thanks