G
Guest
I use the "sum" function in every speadsheet I compose. Normally, as I add
or edit cells that fall within the range of the sum function, the total will
change accordingly.
ie: If I have 20 numbers that add up to, say, 105, if I change a "5" into
"15", the sum function, when it operates correctly, will change the total
from 105 to 115. Conversely, if I change a "15" into a "5", the sum
automatically carries this to the sum total and it then reads "95". This is
as it should be.
What my problem is, (and this is an intermittent problem) the sum does NOT
change when the figures change. Or, sometimes it does.
Sometimes, a simple reboot will fix this. Sometimes not.
I've gone to Microsoft Update and installed all the critaical updates,
including Office XP SP-2 and Office 2002 SP-2 and Office 2003 SP-3.
None of these patches have solved my problem
If I open a new workbook, input a few figures and use the "SUM" function, it
will work correctly. Then when I add more pages that rely on sum totals to
be carried over to multiple cells, the problem begins again.
When it works incorrectly, the only way that I can get the sum to be correct
it to DOUBLE CLICK THE SUM TOTAL CELL. and every other colum or row that
carries the derived value of the sum musr ALSO BE DOUBLE CLICKED in order for
the sum to pick up the changes.
Am I doing something wrong?
or edit cells that fall within the range of the sum function, the total will
change accordingly.
ie: If I have 20 numbers that add up to, say, 105, if I change a "5" into
"15", the sum function, when it operates correctly, will change the total
from 105 to 115. Conversely, if I change a "15" into a "5", the sum
automatically carries this to the sum total and it then reads "95". This is
as it should be.
What my problem is, (and this is an intermittent problem) the sum does NOT
change when the figures change. Or, sometimes it does.
Sometimes, a simple reboot will fix this. Sometimes not.
I've gone to Microsoft Update and installed all the critaical updates,
including Office XP SP-2 and Office 2002 SP-2 and Office 2003 SP-3.
None of these patches have solved my problem
If I open a new workbook, input a few figures and use the "SUM" function, it
will work correctly. Then when I add more pages that rely on sum totals to
be carried over to multiple cells, the problem begins again.
When it works incorrectly, the only way that I can get the sum to be correct
it to DOUBLE CLICK THE SUM TOTAL CELL. and every other colum or row that
carries the derived value of the sum musr ALSO BE DOUBLE CLICKED in order for
the sum to pick up the changes.
Am I doing something wrong?