If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
location of a link in server
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. -- Lowan |
#2
|
|||
|
|||
location of a link in server
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 --------------- Jacob Skaria "Lowan Chan" wrote: 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. -- Lowan |
#3
|
|||
|
|||
location of a link in server
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 -- Lowan "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Lowan Chan" wrote: 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. -- Lowan |
Thread Tools | |
Display Modes | |
|
|