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.

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.

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.

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.