excel not calculating properly

[Guest]

I have rows with a sum and then columns with a total of the sums. If i change
a cell in the row, it will automatically change the sum in the column but not
the total at the bottom of the column
i.e.
A1 = B1+C1+D1
A2 = B2+C2+D2
SUM I can change cells in column b c or d and the total in A will change
BUT

the grand total which is the sum of the column A does not change. If I
manually change the cell in A then the sum of A recalculates OK

Set to auto calculate, using Excel 97 SR2
Any Ideas??
OLEY

Any ideas

 

[Jerry W. Lewis]

What is the formula that is not updating, and what cell is it located
in? IF the formula is =SUM(A:A) and it is located anywhere in column A,
then you have a circular reference that must be corrected before it will
update properly.

The characterization of this group as "Excel Application Errors" in
Microsoft's Office Discussion Groups Home is easily misinterpreted. The
standard name of the group is microsoft.public.excel.crashesgpfs, and
your post has nothing to do with Excel crashing. You would have gotten
an almost immediate response had you posted the question in Worksheet
Functions or General Questions, where it would have been more on topic.

Jerry