| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autosum will not update when I add new data.
I am using Excel in Office 2003, when I add new data into columns that have
an AutoSum the column total no longer updates unless I re enter the formula? I have been using the program for 2 years and have not encounterd this problem before. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autosum will not update when I add new data.
Try
toll|Options|Calculation tab select automatic Mike "Mike HFD" wrote: I am using Excel in Office 2003, when I add new data into columns that have an AutoSum the column total no longer updates unless I re enter the formula? I have been using the program for 2 years and have not encounterd this problem before. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autosum will not update when I add new data.
that's
tools|Options - calculation tab "Mike H" wrote: Try toll|Options|Calculation tab select automatic Mike "Mike HFD" wrote: I am using Excel in Office 2003, when I add new data into columns that have an AutoSum the column total no longer updates unless I re enter the formula? I have been using the program for 2 years and have not encounterd this problem before. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autosum will not update when I add new data.
Maybe you never turned off automatic calculation before?
ToolsOptionsCalculation. Set to Automatic. May have been turned off inadvertantly by a workbook with calc mode set to manual. Note: Excel uses the calc mode of the first workbook opened during a session. Gord Dibben MS Excel MVP On Thu, 27 Nov 2008 12:03:01 -0800, Mike HFD <Mike wrote: I am using Excel in Office 2003, when I add new data into columns that have an AutoSum the column total no longer updates unless I re enter the formula? I have been using the program for 2 years and have not encounterd this problem before. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data in excel wont autosum | Excel Worksheet Functions | |||
| Autosum returns 0 value on data sheet | Excel Worksheet Functions | |||
| Data Filter and AutoSum | Excel Worksheet Functions | |||
| Excel 2003's autosum does not update data in real time | Excel Worksheet Functions | |||
| How to make autosum update totals in excel | Excel Worksheet Functions | |||
Linear Mode
