hyperlink in cell
 

Hi all,

I am not sure I quite understand why, but I tried to place a hyper link in a
cell in the form of UNC path to a network server folder, it would loses the
link. I have it in the following format:

\\Server\Folder_level1\subfolder_level2\subfolder_ level3\subfolder_level4\

When I click on the link, it would give this message "The address of this
site is not valid. Check the address and try again." But after I repaste
the UNC path to the Address textbox, it would work again. This keeps on
happen, even after I saved the link immediately after I repasted the UNC path
tothe address textbox.
Any idea why it keeps losing the linkage? Any suggestions? Thanks in
advance.


Ben


--

hyperlink in cell
 

I can't say why, but try using the Hyperlink worksheet function

=Hyperlink("\\Server\Folder_level1\subfolder_level 2\subfolder_level3\subfold
er_level4\,"Friendly Text")

--
Regards,
Tom Ogilvy


"Ben" wrote in message
...
Hi all,

I am not sure I quite understand why, but I tried to place a hyper link in
a
cell in the form of UNC path to a network server folder, it would loses
the
link. I have it in the following format:

\\Server\Folder_level1\subfolder_level2\subfolder_ level3\subfolder_level4\

When I click on the link, it would give this message "The address of this
site is not valid. Check the address and try again." But after I repaste
the UNC path to the Address textbox, it would work again. This keeps on
happen, even after I saved the link immediately after I repasted the UNC
path
tothe address textbox.
Any idea why it keeps losing the linkage? Any suggestions? Thanks in
advance.


Ben


--

hyperlink in cell
 

Thanks Tom.

--



"Tom Ogilvy" wrote:

I can't say why, but try using the Hyperlink worksheet function

=Hyperlink("\\Server\Folder_level1\subfolder_level 2\subfolder_level3\subfold
er_level4\,"Friendly Text")

--
Regards,
Tom Ogilvy


"Ben" wrote in message
...
Hi all,

I am not sure I quite understand why, but I tried to place a hyper link in
a
cell in the form of UNC path to a network server folder, it would loses
the
link. I have it in the following format:

\\Server\Folder_level1\subfolder_level2\subfolder_ level3\subfolder_level4\

When I click on the link, it would give this message "The address of this
site is not valid. Check the address and try again." But after I repaste
the UNC path to the Address textbox, it would work again. This keeps on
happen, even after I saved the link immediately after I repasted the UNC
path
tothe address textbox.
Any idea why it keeps losing the linkage? Any suggestions? Thanks in
advance.


Ben


--