View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.