Copying a hyperlink spreadsheet - spreadsheet

[Guest2]

I am trying to copy a hyperlink within a spreadsheet on a network drive to another spreadsheet on the desktop. How do you make the link stay the same as it was originally?

At the moment it changes it to make the location where you copy the hyperlink to, so it cannot find the file. (if moving the link to desktop it creates file:///\\C:\documents and setting\ (username)\desktop\documents\test.xls

when before it was

file:///\\192.168.10.102\IT$\documents\test.xls

I want it to stay the same as this

 

[Guest2]

Thanks but there is no properties of a hyperlink, only options to edit the link info.

Found how to do it, you need to set the hyperlink base of the destination file by doing the following -

office home button > prepair > properties > document properties > advanced properties > summary > hyperlink base > change