How to make autosum update totals in excel

G

Guest

the sums in my spreadsheet are not updating as I add new data in the columns
they are defined to total. When I refresh the autosum function, the total
updates, but if I enter new data in the defined area thereafter, the total
remains the same.

This has only just started to happen in the last week. Up until that time
the totals would update automatically.

Any thoughts?
 
A

Anne Troy

There could be 2 reasons for this.
1. Your worksheet is set to manual calculation under Tools-->Options,
Calculation tab (should be automatic).
2. You're inserting cells and the new cells are not becoming part of your
formula. Did you check if the formula is, in fact, still correct after you
enter new data?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
 
G

Guest

Hi Anne,

1. I checked the "calculation" tab in the options menu, it is set to
automatic.
2. I haven't inserted any new cells in the formula range, just updated the
information contained in the existing ones. It was't updating the total
though.

I just closed and reopened the spreadsheet, and now the totals are updating
themselves again! I tried this earlier and it didn't correct the problem...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create autosum formula to show totals for visible data on 2
Autosum will not update when I add new data. 3
Excel formula for adding up sub-totals in time format 2
An odd problem with SUM(A:B) and AutoSum 2
Bizarre Excel 03 Problem - autosum not updating when cells are cha 2
Calculate Totals in Spreadsheet 2
Auto Sum Function 3
How do I sum totals from mulitple worksheets 1

Top