View Single Post
  #1   Report Post  
David E. Gross
 
Posts: n/a
Default 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?