Do you mean that you convert the formulae in those sheets to values
using <copy then Edit | Paste Special | Values ?

Pete

On Aug 19, 3:09*pm, Wanna Learn
wrote:
Hello
Is there a way to value a workbook all at once. *
I have a workbook that has 25 workshheets. *Everymonth I update the report
save it as (v1) then value every worksheet one by one. *
Is there *a way to value the a workbook at once instead sheet by sheet
Thanks