View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Why hyperlink does not work after been copied to another file?

If you are having difficulty copying hyperlinks, I reccomend using the
=HYPERLINK() function. For example:

=HYPERLINK("file:///c:\test\alpha.xls","alpha")

--
Gary''s Student - gsnu200903


"GOH" wrote:

When I copied my hyperlink (pointing to certain files in my harddisk) to
another excel sheet, it seem to lose its link to the file.

Msg: "...address is invalid...."

Why? What is the right way to copy?