I have copied a full 156 sheet workbook completely as another sheet to add
about 32 more sheets to the group. Everything worked fine however all the
formulated cells do not calculate in the new workbook sheets unless I some
how activate them by clicking in the formulated cell and hitting enter. Each
cell is retaining the value it had from the old sheet and has the proper
formula in it to calcuate its own sheets but will not pull the values from
the new sheets until I click in the cell and hit enter to reactivate the
current formula. My question is , is there anyway I can get the enitre
workbook and/or even sheet by sheet to calcuate without having to click in
and out of every box to reactivate them?

Thanks,
Paula