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

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?

Check to make sure Automatic Calculations are turned on.

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

HTH,
Elkar


"CBP" wrote:

> 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?