ExcelBanter - when i change data in a sum forumla, the sum doesn't change?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - when i change data in a sum forumla, the sum doesn't change? (https://www.excelbanter.com/excel-discussion-misc-queries/42890-re-when-i-change-data-sum-forumla-sum-doesnt-change.html)

when i change data in a sum forumla, the sum doesn't change?

Under Tools-Options-Calculation make sure Automatic is checked

"richard_kta" wrote:

i am doing a simple sum formula, using it several times in the worksheet, and
it used to work fine, however, suddenly now the formulas are only working
after the initial calculation, if i go back and change data later on, the
formula doesn't reflect any changes and special pasting of the formula only
reproduces the value of the original calculation! I want the Sum function to
work as it should. Reflect changes as they are made and be able to paste a
function to another group of cells!