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?