Have you tried clicking on Edit then clicking on Paste Special or Paste as
Hyperlink?

"TWIN HYPE" wrote:

When I copy a worksheet to a new book excel removes part of the hyperlink
directory tree from each hyperlink rendering them useless (the change is
identicle for all the links). Am I doing something wrong?