Our tutorial in this article will show you where the default calculation setting is located so that you can switch it to the automatic option.  

Enable Automatic Calculation by Default in Excel 2013

The steps in our guide below will show you how to change the default calculation options for any workbook that you open in your copy of Microsoft Excel 2013. Once you have completed these steps, the formulas in your worksheets will automatically calculate as you update values in cells that are a part of the formula.  

   

   

        As mentioned previously, this changes the default calculation option in Excel 2013. If you would prefer instead to set the calculation option on a per-worksheet basis, then you can click the Calculation Options button on the Formulas tab and select the Automatic option.

    Is your Excel worksheet displaying the formula instead of the result of the formula calculation? You can change the formula display settings in Excel 2013 as well so that you can choose what is displayed in cells that contain formulas. He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices. Read his full bio here.

How to Turn On Automatic Calculation in Excel 2013 - 14How to Turn On Automatic Calculation in Excel 2013 - 23How to Turn On Automatic Calculation in Excel 2013 - 10How to Turn On Automatic Calculation in Excel 2013 - 87How to Turn On Automatic Calculation in Excel 2013 - 86