Why lose hyperlink when copying and pasting?

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

[Anna]

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?