Sum function not updating

  • Thread starter Thread starter James
  • Start date Start date
J

James

The sum function in Excel has stopped updating. If I
enter new data, the sum function will not calculate it,
unless I retype the function again.

For example:
Volumes
10
15
20
25

I currently have the next cell reading "=sum(C2:C5)" This
function should give me a total of 70. However, if I
change one of the cells, like the first cell that contains
10 to 50, the function will not update. It shuold
automatically update any calculations that are made in
cells C2 to C5, correct?

Why is Excel not doing this?

The frustrating thing is that if I go back and retype the
function after data has been changed, it will update.
However, I cannot afford to have to constantly go back and
retype the function everytime the data is changed, nor
should that be required according to the way Excel works.

In addition, even if I go to an empty cell and type =c9,
where C9 is a blank cell, and then go back to c9 and type
data into the cell = the dependant cell will not update.

HELP!
 
Hi James
you may have 'automatic calculation' disabled. Does hitting F9 update
the firmula result?. If yes, goto 'Tools- Options - Calculation' and
enable 'automatic calculation'

Frank
 
Back
Top