Formula total doesn't change

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Lately I've noticed that when I have simple formula, such
as:

Cell D1 contains: =sum(A1+B1+C1)

If I change the contents in A1, it doesn't reflect the
change in D1(The Total).

If anyone has an answer for me please respond.

Thanks!!!
 
Tim said:
Lately I've noticed that when I have simple formula, such
as:

Cell D1 contains: =sum(A1+B1+C1)

If I change the contents in A1, it doesn't reflect the
change in D1(The Total).

If anyone has an answer for me please respond.

Thanks!!!
Click to expand...

I always start with the most obvious things. Is calculation set to manual
instead of automatic. You can tell as there will be calculate word in the
status bar. To turn on go to tools/options/calculation and set to automatic
from there.

HTH

Andy B
 
Tim
I can't replicate this behaviour, but a better
way (more economical) is
=SUM(A1:C1) or simply

=A1+B1+C1

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Hi Tim,

Please click "Tools", then choose "Options" and then
select "Calculation. Here, just ensure that you have
selected "AUTOMATIC" and not manual !!!

Thanks & regards,

Manish
 
Back
Top