Excel Formula Issue
 

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

Excel Formula Issue
 

Hi,

Am Thu, 11 Jul 2013 20:27:28 +0100 schrieb smalone1:

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.

in your sheet the calculation is set to "Manuell"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Excel Formula Issue
 

On Thu, 11 Jul 2013 20:27:28 +0100, smalone1 wrote:

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.)


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...