Niek,

Another thing I noticed. When I create a new sheet and make a SUM of a
couple of cells, the status bar is as expected. If I svae the file the status
bar remains the same. If I then close and re-open the sheet and chaneg any of
the values that make up the SUM and press ENTER, the statyus bar shows
CALCULATE and it keeps showing that. So that's the big difference between
initial state and re-opened state. Changing AUTO to MANUAL calculation does
not change the status bar.

Sven

"Niek Otten" wrote:

Hi Sven

Check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sven Martin" wrote in message ...
| When I open Excel and make a SUM of several cells, the SUM is displayed and
| calculated correctly. If I save the file and re-open it and change any value
| of one of the cells in the SULM, the result stays the same, the SUM is not
| recalculated. If I create a new SUM in this Excel file, the result returns
| ZERO. Calculation is set to AUTOMATIC, F9 does not change this.