Thread: Hyperlink Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Hyperlink Help

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")


Try this form. I have never found it to fail.
--
Gary''s Student - gsnu200749


"Erika" wrote:

I did try that method however I end up with the same results.

"Gary''s Student" wrote:

The best way to protect hyperlinks is to use the:
=HYPERLINK() function.

--
Gary''s Student - gsnu200749


"Erika" wrote:

I have used the Insert Hyperlink feature to create hyperlinks back to various
word documents from Excel. The hyperlinks seem to work great when I create
them and even for a couple days after that. Then when I use them again I get
the
following error message

'Can not find the specified file'

I can recreate the link but the same thing happens it works great for a
couple days and then stops working.

Any ideas?