Im running Office 2007. When I add a list of numbers to a worksht and
use the standard formula to add the column eg: sum=(c2:c33) it will not
recognize any additions or changes. I must double click on the cell
containing the formula in order to get the updated total. I am
stumped. Thanks
You're in Manual Calculation mode.
Excel's calculation mode is a global setting but is also stored in
each workbook. If the first workbook you open is in Manual
Calculation, then all later workbooks opened in that Excel session
will also be in Manual Calculation. Any saved workbook will include
the current calculation option, with effect the next time you open
that workbook in Excel.
Therefore, you should check the calculation mode after opening your
workbook(s) but before starting a simulation. In Excel 2010 or 2007,
click Formulas » Calculation Options. In Excel 2003 or earlier, click
Tools » Options » Calculation.
If you find you're in Manual Calculation and you want to be in
Automatic Calculation, change it and save every workbook. (You may
need to change something in each workbook. Options are not always
saved if there were no actual changes to the workbook.)