Excel Formula Issue

S

smalone1

Im running Office 2007. When I add a list of numbers to a worksht an
use the standard formula to add the column eg: sum=(c2:c33) it will no
recognize any additions or changes. I must double click on the cel
containing the formula in order to get the updated total. I a
stumped. Thank
 
C

Claus Busch

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

Stan Brown

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top