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,
|