ExcelBanter - Why does excel change my hyperlinks when I copy a worksheet?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Why does excel change my hyperlinks when I copy a worksheet? (https://www.excelbanter.com/new-users-excel/42328-why-does-excel-change-my-hyperlinks-when-i-copy-worksheet.html)

TWIN HYPE

Why does excel change my hyperlinks when I copy a worksheet?

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?

Mike

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?

All times are GMT +1. The time now is 03:44 AM.