Right-click the sheet tab and choose "Move or Copy." Choose "new book", and
check "Create a copy," then click OK. You will be in the new book. Click the
rectangle at the intersection of row and column headers, to select all, then
Edit copy followed by Edit Paste Special Values. Save the new file.

"Mister B" wrote:

How to paste formated sheets to new file sheet? Formated sheet has artwork
(logo) and formulas that should carry as values only