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

"Miranda" wrote in message
...
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?