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

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.

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

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561692