Cells with formulas no longer update

[kooths]

We use existing excel files that contain some (very simple) fomulas. Our application opens these files with XLSReadWriteII5 (version 5.20.30), fills some cells with numbers that the formula cells are referring to (like with ASheet.AsFloat[ACol,ARow] := 3.45;) and saves the file. When opening these files later with Excel all cells in the workbook are frozen. There is no way to make formula cells to update or recalculate within Excel (F9 does not work, the recalcuation option is set to automatic etc.). When editing a formula cell (even just by adding a blank and then deleting it), Excel recalculates the cell correctly. Also, if we overwrite cells that contain formulas, the formula is still there but the cell shows the values that our application writes into it.

We have never experienced this strange behavior with XLSReadWriteII4. Please help!

Greetings

Stefan Kooths

[larsa]

Hello

Please send me the excel file that you read.