sum doesn't update total without double-click of cell
 

In a spreadsheet, using formula like "A1 + B1" to get the
sum of values in cells A1 and B1 to show in a third cell.
The total in the third cell does not update automatically
after changing the value in one of the two cells (e.g., A1).
Only after double-clicking the third cell, is the proper total
displayed.

Any ideas why this is happening?

Set your calculations to automatic under toolsoptionscalculations

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"David E. Gross" <David E. wrote in message
...
In a spreadsheet, using formula like "A1 + B1" to get the
sum of values in cells A1 and B1 to show in a third cell.
The total in the third cell does not update automatically
after changing the value in one of the two cells (e.g., A1).
Only after double-clicking the third cell, is the proper total
displayed.

Any ideas why this is happening?