Hyperlinking on Network drives

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently placing hyperlinks in my worksheet - I am setting the link to eg

P:\Sharename\Folder1\Folder2\fileIwishtoOpen

However when I go back and try to use the llink it decides to put in my full
server name and remove my drive letter.

Is there a way that, when I enter the path it keeps the drive letter

TIA
 
Hi mmc308

I dont understand it fully, but I've always found that the hyperlink
updates to wherever it resides at the time. If you copy the file to
a flash drive and take it home and paste it on your C drive then
then that is the path it will show. You can edit the file at home and
take it back to work and paste it onto someone elses computer
and the hyperlink path will update to show their server name.

HTH
Martin
 
Thanks for your advice on this

I have found some info on this forum in respects to the
=Hyperlink("P:\Name","Friendly Name") from D Peterson

Many Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapped vs Network drives 2
Paste Hyperlink result as working hyperlink 2
Create New Folder 3
Hyperlink to a folder 2
Hyperlink Problem 2
Outlook 2007 changes hyperlink to file from unc to drive letter 0
Hyplinking Question 2
Can UDF return a customized hyperlink? 3

Back
Top