A pasted formula won't calculate?

[PaulaJ]

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

 

[bj]

check <tools><options><Calculation>
see if it is set to automatic
also try (F9) to calc now

 

[PaulaJ]

No it didnt I tried cal sheet and f9. The only thing I can do is click the
cell and put my cursor in the cell in the top formula bar like I am going to
type something in the cell with the formula in it and hit enter. Then it
accepts the formula in the cell that is already there and written but seems
to not activate. I tried all the auto calcuates though

 

[Dave F]

The cell in which you put the formula is probably formatted as text. Format
it as general.

Dave

 

[Gord Dibben]

Paula

Select the formula cells.

Edit>Replace

What: =

With: =

Replace all. This resets the formulas to formulas in most cases.


Gord Dibben MS Excel MVP