Value a workbook

W

Wanna Learn

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
 
P

Pete_UK

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

Pete
 
W

Wanna Learn

Thanks Pete
Yes that is what I do for each sheet
Do you mean that you convert the formulae in those sheets to values
using <copy> then Edit | Paste Special | Values ?

Pete
Click to expand...
 
D

Dave Peterson

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!
 
Top