Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula issue. | Excel Worksheet Functions | |||
Formula Issue | Excel Worksheet Functions | |||
IF OR Excel Formula Issue | New Users to Excel | |||
Excel Formula Issue | Excel Discussion (Misc queries) | |||
Excel 2003 Formula Issue | Excel Discussion (Misc queries) |