I would love to know why Excel does this as I have had the same problem today
and its a workbook that we have used everyday this month and it is used by
the same person everytime, then for some reason, this morning it has somehow
set itself to Manual Calculation. Anyone got any ideas?

"Roger Govier" wrote:

Hi Wozza

FYI the calculation mode is set by the Calculation setting of the first
Workbook opened in that session of Excel.
Maybe the first book you opened was from someone else, and they had the
calculation set to manual.

Regards

Roger Govier



Wozza wrote:

Thanks Biff...not sure how it got set to manual!

"Biff" wrote:



Check and make sure that calculation is set to automatic.

ToolsOptionsCalculation

Biff

"Wozza" wrote in message
...


=SUM(G5:G11) if I change any cell in the range, the sum is not performed.
I
have to select the sum cell, F2 then Enter in order to get the sum to work