If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink to folder on Save
Hi
I'm losing the link to my folder when I save my worksheet having set it up a hyperlink. I've tried switiching off 'update links on Save' in the Web Options which seems to work OK but when anyone else opens the file form another network PC, the link is lost again when they save the document. Is there anyway I can lock the hyperlink down so the address doesn't get aleter when its saved on other network PCs? |
#2
|
|||
|
|||
Hyperlink to folder on Save
Try using the HYPERLINK() function instead
=HYPERLINK("file:////c:\filename.xls","Book1") -- Jacob (MVP - Excel) "Felix" wrote: Hi I'm losing the link to my folder when I save my worksheet having set it up a hyperlink. I've tried switiching off 'update links on Save' in the Web Options which seems to work OK but when anyone else opens the file form another network PC, the link is lost again when they save the document. Is there anyway I can lock the hyperlink down so the address doesn't get aleter when its saved on other network PCs? |
Thread Tools | |
Display Modes | |
|
|