Excel-based form not auto-calculating

When working in an Excel-based form (such as a Divorce Financial statement, rule 401 long or short form, child support guidelines worksheet, a probate "account" form, or a real estate HUD form), when you enter numbers, the totals do not update to reflect the numbers you have entered - in other words, the form does not appear to auto-calculate.

By default, Microsoft Excel auto-calculates formulas in a document. However, it is possible to turn off this feature. To turn this feature back on, follow the steps below for your particular version of Microsoft Excel.

For Excel 2007/2010/2013/2016:

  1. Click on the File tab (or the Office "orb" button in the top-left corner), then choose Options (or Excel Options).
  2. On the left-hand side, click on Formulas.
  3. Under Calculation options, under Workbook Calculation, choose Automatic.
  4. Click OK to close the window and save the changes.

For Excel 2003 and earlier:

  1. In Excel, click the Tools menu, then select Options.
  2. Click the Calculations tab.
  3. Make sure that the calculation option is set to Automatic, and not Manual.
  4. Click OK to close the window and save the changes.

The form should now auto-calculate properly.

Was this article helpful?
0 out of 0 found this helpful


Article is closed for comments.
Powered by Zendesk