software

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 --gt; Options --gt; Calculation Tab --gt; Check quot;Automaticquot;

HTH,
Elkarquot;CBPquot; wrote:

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