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

 

[wozencl]

It's been a while since I've used Excel but I think you should be able right click on the hyperlink in the source file, then Properties and uncheck Relative hyperlink.

If it's not that it's something similar

 

[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

 

[wozencl]

Ah I see. It's moved since the last time I had to find it, in work (Excel 2000) it's simply File > Properties > Summary.


Good job!