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?
|