How do I save a single spreadsheet in a workbook in excel

[Guest]

I've got a workbook with multiple calculations on each worksheet, one
worksheet is a report sheet and need to be saved without the formulas and
references to the other sheets.

 

[VBA Noob]

Hi,

Right Click on the report sheet. Select move or copy. Tick the copy
option. Next click the drop down "to book" and select the new book
option.

Then select all cells and copy, next right click and choose Paste
special and then values.

Hope that's what you wanted.

VBA Noob