Functions not "recalculating" when input changes ???
 

I'm using Excel 2002 (on my PC running XP Home)

I'm basically a novice to excel, but can create simple templates for simple
needs. I'm currently creating a template that will add the sum of a certain
number of cells (and a few other things). I've added the simple function to
add those cells up, but when the inputs within those cells change, the
result doesn't change automatically.

For example:
In cell E107 I've added the function: =SUM(E6:E104)
The result that came up after I added this function is the correct amount.
The problem is, when I change the amount entered into one of the cells
within the E6-E104 range, the result in E107 remains the same as it was
prior to the change (and therefore no longer correct).
It does not recalculate the sum automatically.

I have figured out that if I click on the E107 cell and then the function as
it's displayed in the open input at the top (sorry don't know what to call
this input, but it's the same as where you enter web addresses in Internet
Explorer) (told you I was a novice...lol) then the result changes to the
correct amount.

What can I do to have this function recalculate automatically as soon as a
cell within the range changes (as it has in the past)?

Thanks in advance...

You have to turn on Automatic Calculation:

Tools-Options-"Calculation" Tab-Check "Automatic" under calculation
--
Regards,
Dave


"FISH" wrote:

I'm using Excel 2002 (on my PC running XP Home)

I'm basically a novice to excel, but can create simple templates for simple
needs. I'm currently creating a template that will add the sum of a certain
number of cells (and a few other things). I've added the simple function to
add those cells up, but when the inputs within those cells change, the
result doesn't change automatically.

For example:
In cell E107 I've added the function: =SUM(E6:E104)
The result that came up after I added this function is the correct amount.
The problem is, when I change the amount entered into one of the cells
within the E6-E104 range, the result in E107 remains the same as it was
prior to the change (and therefore no longer correct).
It does not recalculate the sum automatically.

I have figured out that if I click on the E107 cell and then the function as
it's displayed in the open input at the top (sorry don't know what to call
this input, but it's the same as where you enter web addresses in Internet
Explorer) (told you I was a novice...lol) then the result changes to the
correct amount.

What can I do to have this function recalculate automatically as soon as a
cell within the range changes (as it has in the past)?

Thanks in advance...