Excel Guides

Setting the Calculation Default in Excel

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:

  1. Open the workbook that contains the macros.
  2. On the Developer tab, click Macro Settings.
  3. Select the Trust access to the VBA project object model check box.
  4. Click OK two times.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.