You can set the calculation default in Excel so that all new workbooks use the same calculation mode. By default, Excel uses automatic mode, where it automatically recalculates formulas when cells that they depend on change. You can also set it to manual mode, where formulas are not automatically recalculated. To do this, open the Excel Options dialog box, click Formulas in the left pane, and then under Calculation options, select the Automatic or Manual option.
If you have a workbook that was created in an earlier version of Excel and it contains macros that call the Calculate method, those macros might not work correctly in Excel 2016. This is because the new default calculation mode is set to manual. To fix this problem, you can set the default calculation mode back to automatic by following these steps: