View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paris[_2_] Paris[_2_] is offline
external usenet poster
 
Posts: 1
Default Sum isn't updating automatically with new data entry

Should be a simple fix.

I am summing numbers in a column. When I enter new data in the column, the
sum doesn't re-calculate automatically. If I re-type the same sum formula or
click on the sum cell and hit return again, it re-calculates. It used to do
this automatically with every new entry in the column. Have I unwittingly
changed a setting to make this happen? How do I reset it so the total is
automatically kept current?