You may use paste special instead of paste and make sure the check box of
'all' is checked.

"Infidel70" wrote:

When copying hyperlinks from one excel spreadsheet to another, the hyperlink
is being lost in the pasting. Any ideas why and how to combat this?