Hi
goto 'Tools - Options - Calculate' and enable automatic calculation

--
Regards
Frank Kabel
Frankfurt, Germany
"ptree" schrieb im Newsbeitrag
...
I have formulas in certain cells on a spreadsheet. When I change one of
the
values within one of the cells, the sum does not change until I go up to
the
formula bar on top and click on the check mark. This has never happened
before so I must have hit some control button. I want my sums to change
automatically when I change a cell value.