Check this page on Charles Williams' site:

http://www.decisionmodels.com/calcsecretsf.htm

and look for:

"CALCULATE" in Status Bar

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sven Martin" wrote in message ...
| 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.
|
|
|