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
|
|||
|
|||
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... |
#2
|
|||
|
|||
excel hyperlink not working
Take a look at the help for the worksheet function
=hyperlink() 'Use the UNC Path =HYPERLINK("\\servername\sharename\folder\file.ext ension","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... |
Thread Tools | |
Display Modes | |
|
|