While closing the workbook the dialog box with the message like "Microsoft Office Excel recalculates formulas" displayed. How can we resolve this problem?

This is the normal behavior of MS Excel. The problem is the 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 their values in the workbook. Therefore, it changes it, and if you want to save that evaluated value, we have to save the workbook. 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.