Formula won't update with new data

[D'oug]

On all my Excel documents, when I create a formula, say just adding a column
of numbers, if I go back and change one of the numbers of data, the total
won't change to reveal the new total. Did I accidentally hit a command key or
something?

thanks.
doug

[Paul B]

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

"D'oug" <[email protected]> wrote in message
news:[email protected]...
> On all my Excel documents, when I create a formula, say just adding a
column
> of numbers, if I go back and change one of the numbers of data, the total
> won't change to reveal the new total. Did I accidentally hit a command key
or
> something?
>
> thanks.
> doug

[warman1956]

I also had the problem relayed by D'oug. I went into tools-options-calculation and found that "automatic" was already checked. Could there be anything else that is preventing the spreadsheet from updating formulas?
Thanks!

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

"D'oug" <[email protected]> wrote in message
news:[email protected]...
> On all my Excel documents, when I create a formula, say just adding a
column
> of numbers, if I go back and change one of the numbers of data, the total
> won't change to reveal the new total. Did I accidentally hit a command key
or
> something?
>
> thanks.
> doug