Not summing a columns?
 

When summing a column in Excel 2000. If additional numbers are added the
formula does not recalculate the amount. Unless I click on the formula in the
formula bar again and press enter. Then it works fine. Is there a way to make
it calculate automatically? It was working fine. Is there an option I turned
off somewhere?

Thanks,

Nicole, try tools, options, calculation, and make sure automatic is checked

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Nicole" wrote in message
...
When summing a column in Excel 2000. If additional numbers are added the
formula does not recalculate the amount. Unless I click on the formula in
the
formula bar again and press enter. Then it works fine. Is there a way to
make
it calculate automatically? It was working fine. Is there an option I
turned
off somewhere?

Thanks,

Hi Nicole,
Normally if you have a problem with a function you would post what
you are using. In this case, I think your problem is that you have
turned calculation to manual instead of automatic (as Paul just said).
Tools, Options, Calculation (tab), Calculation: automatic

If this has become a problem and you don't know how calculation is
begin turned off take look at
http://www.mvps.org/dmcritchie/excel...esp.htm#addins
for some help with checking if calculation is turned off when you
start Excel. If may help you find out what you did or used that turned
it off in the last session.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nicole" wrote in message ...
When summing a column in Excel 2000. If additional numbers are added the
formula does not recalculate the amount. Unless I click on the formula in the
formula bar again and press enter. Then it works fine. Is there a way to make
it calculate automatically? It was working fine. Is there an option I turned
off somewhere?

Thanks,