Value a workbook
 

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

Value a workbook
 

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

Value a workbook
 

Thanks Pete
Yes that is what I do for each sheet
<copy then Edit | Paste Special | Values
"Pete_UK" wrote:

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

Value a workbook
 

You could use a macro that loops through each worksheet and does edit|copy,
edit|paste special|values.

But you could try this, too.

Select all the worksheets in the workbook
(rightclick on one worksheet tab and choose select all sheets)

Then select all the cells in that sheet (ctrl-a a few times)
edit|copy
edit|paste special|values

Then ungroup the sheets (rightclick on one of the selected tabs and choose
ungroup sheets)

Then check the results.

If it worked, ok.

If not, then close without saving -- or hit edit|undo!

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

--

Dave Peterson