Hyperlink to .pdf file in shared drive

[mike2227]

I am trying to add hyperlinks to pdf files from a shared drive in my office throughout an excel workbook, but can not get them to work. I tried using the insert hyperlink option as well as the "=HYPERLINK()" formula. They both work for files on my C: drive, but not from the shared drive. I always get an error that states "Cannot open the specified file."

My hyperlink formula looks something like:
=hyperlink("S:\file_path\doc_name.pdf", "Click Here")

Is there a different way of doing this that might work? This method works perfectly for files in my C drive.

Please advise.

Thank you,

Mike

 

[RedBeard]

Hover over the hyperlink, it's most likely pointing to your local drive.
Use the UNC path to the file location and it should work. (i.e. \\myserver\files\path\file.pdf)

 

[mike2227]

Thank you RedBeard.
The URL was pointing to the shared drive, but I tried this anyway and it still gives the same error. Is there anything I need to do differently since it is a shared drive? Maybe I did this incorrectly. This is what I did:
=hyperlink("\\S:\path\file.pdf","Click Here")
When I hover over the link, it shows the same path that i typed out.
I also tried ("file\\S:\....) and it gives the warning that the link may be dangerous (as it does for the local drive) and then gives the same error message...

 

[RedBeard]

The S: bit is your mapped drive, you need the full path to the file.

If you don't know the full path (i.e. UNC path), open up a command prompt and type net use and hit enter.

That should show you what S: is actually pointing at.