Easily convert all formulas in 3d spreadsheet to values?
 

I have a large Excel 3-D workbook with 40 sheets, each with multiple complex
formulas.
At the end of each month I archive the sheet and would like to convert the
formulas into values to reduce the size of the workbook.
Can this be done in a few easy steps, as I don't want to copy and special
paste as values 40 times over?

Thanks

Easily convert all formulas in 3d spreadsheet to values?
 

Hi

Group the sheets first, then select all of the cells on the visible sheet
(Ctrl+A) and Paste Special/Values.

Don't forget to ungroup the sheets after!

Andy.

"Jazza" wrote in message
...
I have a large Excel 3-D workbook with 40 sheets, each with multiple
complex
formulas.
At the end of each month I archive the sheet and would like to convert the
formulas into values to reduce the size of the workbook.
Can this be done in a few easy steps, as I don't want to copy and special
paste as values 40 times over?

Thanks

Easily convert all formulas in 3d spreadsheet to values?
 

Record a Macro (ToolsMacroRecord...) that copies and PasteSpecials each
sheet. Add a hot key (like Ctrl-V) to convert them all to values. Then all
you have to do is press your hot key.

"Jazza" wrote:

I have a large Excel 3-D workbook with 40 sheets, each with multiple complex
formulas.
At the end of each month I archive the sheet and would like to convert the
formulas into values to reduce the size of the workbook.
Can this be done in a few easy steps, as I don't want to copy and special
paste as values 40 times over?

Thanks