Thread: Autosum will not update when I add new data.
View Single Post
  #3   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.
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.
Reply With QuoteReply With Quote