Somehow you turned off "Auto Calc"......go to Tools/Option/Calculation and
make sure "Automatic" is selected.

HTH
JG

"denobs" wrote:

ive entered a formula which adds a column of figures and before whenever i
change theses figures the formula automatically corrects itself with the
changes
but now this no longer happens and after making my changes i need to
re-enter the formula for the correct the balance - can anyone tell me what is
going on?