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 want to clear the checkbox, do one of the following:

•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.

•When working in macOS, select Data > Calculation mode > Calculate and clear the Before saving checkbox.