My formula cell has stopped adding the preceding cells.
 

I am always using the sum formula to add up preceding cells and somehow the
formula has stopped working automatically. If I change one of the preceding
cells to a different number, the formula cell does not automatically change.
I have to go back and erase the formula and re-type it in to get the correct
number. Please advise.

My formula cell has stopped adding the preceding cells.
 

Hi,

Have you checked ToolsOptionsCalculation? Automatic should be selected.

HTH

"Miriam" wrote:

I am always using the sum formula to add up preceding cells and somehow the
formula has stopped working automatically. If I change one of the preceding
cells to a different number, the formula cell does not automatically change.
I have to go back and erase the formula and re-type it in to get the correct
number. Please advise.