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