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?

Sum isn't updating automatically with new data entry
 

Paris wrote:
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?

Check Tools | Options | Calculation and make sure Automatic is selected.

Sum isn't updating automatically with new data entry
 

Go to Tools|Options and in the Calculation tab ensure Automatic is set
on.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125772