Why lose hyperlink when copying and pasting?

I

Infidel70

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

Anna

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