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