Instead of copying, do a SAVE AS. I had the same question a while back, and
this is the solution.

Carole O

"MiaCat" wrote:

Can I copy a workbook containing hyperlink bookmarks and have those
hyperlinks refer to cells in the new workbook?