Category / Section
While closing the workbook the dialog box with the message like "Microsoft Office Excel recalculates formulas" displayed. How can we resolve this problem?
1 min read
This is the normal behavior of MS Excel. The problem is formula, because we don't evaluate any Formula. For this, we tell MS Excel that it should evaluate every formula in the workbook. After MS Excel evaluates those formulas, it stores its value in the workbook, therefore it changes it, and if you want to save that evaluated value, we have to save workbook. And MS Excel warns about this change when we open the workbook. The changes are persisted if we save the workbook and this is the default and normal behavior of XlsIO.