software

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?

There could be 2 reasons for this.
1. Your worksheet is set to manual calculation under Tools--gt;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

quot;Mirandaquot; gt; wrote in message
...
gt; the sums in my spreadsheet are not updating as I add new data in the
gt; columns
gt; they are defined to total. When I refresh the autosum function, the total
gt; updates, but if I enter new data in the defined area thereafter, the total
gt; remains the same.
gt;
gt; This has only just started to happen in the last week. Up until that time
gt; the totals would update automatically.
gt;
gt; Any thoughts?
Hi Anne,

1. I checked the quot;calculationquot; 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...
quot;Anne Troyquot; wrote:

gt; There could be 2 reasons for this.
gt; 1. Your worksheet is set to manual calculation under Tools--gt;Options,
gt; Calculation tab (should be automatic).
gt; 2. You're inserting cells and the new cells are not becoming part of your
gt; formula. Did you check if the formula is, in fact, still correct after you
gt; enter new data?
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Mirandaquot; gt; wrote in message
gt; ...
gt; gt; the sums in my spreadsheet are not updating as I add new data in the
gt; gt; columns
gt; gt; they are defined to total. When I refresh the autosum function, the total
gt; gt; updates, but if I enter new data in the defined area thereafter, the total
gt; gt; remains the same.
gt; gt;
gt; gt; This has only just started to happen in the last week. Up until that time
gt; gt; the totals would update automatically.
gt; gt;
gt; gt; Any thoughts?
gt;
gt;
gt;

EWWW. Well, if it keeps happening to you, Miranda, try cleaning up your hard
drive, okay?
www.officearticles.com/misc/h...hard_drive.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Mirandaquot; gt; wrote in message
...
gt; Hi Anne,
gt;
gt; 1. I checked the quot;calculationquot; tab in the options menu, it is set to
gt; automatic.
gt; 2. I haven't inserted any new cells in the formula range, just updated the
gt; information contained in the existing ones. It was't updating the total
gt; though.
gt;
gt; I just closed and reopened the spreadsheet, and now the totals are
gt; updating
gt; themselves again! I tried this earlier and it didn't correct the
gt; problem...
gt;
gt;
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; There could be 2 reasons for this.
gt;gt; 1. Your worksheet is set to manual calculation under Tools--gt;Options,
gt;gt; Calculation tab (should be automatic).
gt;gt; 2. You're inserting cells and the new cells are not becoming part of your
gt;gt; formula. Did you check if the formula is, in fact, still correct after
gt;gt; you
gt;gt; enter new data?
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;Mirandaquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; the sums in my spreadsheet are not updating as I add new data in the
gt;gt; gt; columns
gt;gt; gt; they are defined to total. When I refresh the autosum function, the
gt;gt; gt; total
gt;gt; gt; updates, but if I enter new data in the defined area thereafter, the
gt;gt; gt; total
gt;gt; gt; remains the same.
gt;gt; gt;
gt;gt; gt; This has only just started to happen in the last week. Up until that
gt;gt; gt; time
gt;gt; gt; the totals would update automatically.
gt;gt; gt;
gt;gt; gt; Any thoughts?
gt;gt;
gt;gt;
gt;gt;