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

"MartinW" wrote:

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