software

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

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.

quot;Jazzaquot; gt; wrote in message
...
gt;I have a large Excel 3-D workbook with 40 sheets, each with multiple
gt;complex
gt; formulas.
gt; At the end of each month I archive the sheet and would like to convert the
gt; formulas into values to reduce the size of the workbook.
gt; Can this be done in a few easy steps, as I don't want to copy and special
gt; paste as values 40 times over?
gt;
gt; Thanks
Record a Macro (Toolsgt;Macrogt;Record...) 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.

quot;Jazzaquot; wrote:

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