Autosum will not update when I add new data.

[Mike HFD]

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.

 

[Mike H]

Try

toll|Options|Calculation tab
select automatic

Mike

 

[Mike H]

that's

tools|Options - calculation tab

Try

toll|Options|Calculation tab
select automatic

Mike

 

[Gord Dibben]

Maybe you never turned off automatic calculation before?

Tools>Options>Calculation. 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