Data added to a spreadsheet will not automatically add, help!

C

CBP

I have an existing spreadsheet that contains a very simple sum formula at the
end of each column. It has always worked until recently. Now when I add
data it is not autmatically summed at the bottom of the column. To get the
amount added in I have to click on the cell with the formula, click the end
of the formula and hit enter. I checked the formula and it includes all
cells in the columns. Any idea what is happening to such a simple function?
 
E

Elkar

Check to make sure Automatic Calculations are turned on.

Tools --> Options --> Calculation Tab --> Check "Automatic"

HTH,
Elkar
 
Top