Click the Office Ribbon Button(colorful round circle at the top Left
corner)Excel OptionsFormulasCalculation OptionsWorkbook
CalculationSelect the AUTOMATIC Option Button and give Ok…

If the above doesn’t solve your problem, then check your formula whether
it’s covering new input value cell.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"DY" wrote:

I am currently using Excel 2007. I have a spreadsheet that I want to use to
do some analysis of various situations. So here is my problem. I have
several columns that have totals at the bottom. I have no problem getting
the columns to total initially. However, if I plug in another number in the
column, the total stays the same and won't refresh or re-total the column. I
don't recall that this was a problem when I worked with Excel 2003. Can
someone please tell me how to get the totals to update when I enter some new
numbers in the column? Thanks in advance for the help.