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

D

David E. Gross

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?
 
P

Peo Sjoblom

Set your calculations to automatic under tools>options>calculations

--
Regards,

Peo Sjoblom

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