Recalculate formulas when saving a document

When the user saves the document, recalculation of outdated formula values is done if the  Calculate before saving checkbox is selected in the drop-down menu of the Calculate data button.

In automatic recalculation mode, formulas are always recalculated before saving, therefore the  Calculate data button is disabled.

In manual recalculation mode, the Calculate before saving checkbox is selected by default. If you need to cancel the recalculation, on the Data tab, click the arrow to the right of the  Calculate data button and clear the Calculate before saving checkbox in the drop-down menu.