[Solved] Error code "err: 522" in spreadsheet

[johnlim]

I regularly get err:522 appear in the cells in Calc for the current file i have been working on. If I place the cursor over the cell with the error code, the formula in the cell appears correct. If i retype the formula again into the cell, or drags the formula from the adjoining cell if it is a row with the same formula, then the correct results appear in that error cell. Sometimes I notice the err code re-appear in the same cell, and i have to re-type the formula again. Please see the attached tif file for sample of the problem. How can I eliminate this problem? This is quite a large model and it is quite disconcerting for the audience to see error codes randomly peppering the model. Thank you for your help.

Edit: Hagar: changed the title and corrected the error code as said by OP (removed that post).

[probe1]

See F1 online help, OpenOffice.org Calc, error codes

Check Tools>Options>OpenOffice.org Calc>Calculate and activate "Iterations".

Does this help?

[johnlim]

Thank you Winfried.
Yes, that seem to solve the problem.