How to fix an Excel spreadsheet that’s not auto calculating

Matthew Adams
by Matthew Adams
Windows & Software Expert
0 Comments
Download PDF
Affiliate Disclosure

Excel spreadsheet not automatically calculating

Excel is essentially one big calculator that can also display numerical data in the form of spreadsheet tables and graphs. Formulas (or functions) are the cornerstone of Excel that perform a multitude of calculations and display them within spreadsheet cells.

Excel’s formulas make it one of the most essential MS Office applications.

Ad

However, sometimes Excel might not always calculate formulas automatically. When that happens, the formulas don’t automatically update when users change the values they’re based on.

Alternatively, sometimes Excel might just display the formulas within cells instead of their results. If either of those scenarios sounds familiar, check out some of the resolutions for them below.

What can I do if an Excel spreadsheet is not auto calculating?

1. Select the Automatic Calculation option

  1. If Excel functions don’t automatically calculate when you modify the values they’re based on, the default automatic calculation mode probably isn’t enabled. Click the File tab at the top left of Excel.
  2. Click Options, which opens the Excel Options window.
    Excel Options window excel spreadsheet not automatically calculating
  3. Click the Formulas tab on the left of the window.Formulas tab excel spreadsheet not automatically calculating
  4. Is the Manual option there selected? If so, select the Automatic setting.
  5. Click OK to close the Excel Options window.

2. Turn off Show Formulas

If an Excel spreadsheet displays all its formulas within cells, the Show Formulas option is probably enabled. To disable that option, click the Formulas tab in Excel. Then click the Show Formulas button on that tab.

You can also press the Ctrl + ` hotkey to toggle the Show Formulas button off/on.

Show formulas button excel spreadsheet not automatically calculating


3. Check the cell format for formulas

Excel will also display formulas instead of calculated output in cells when the cells have a text format. To check if that’s the case, select a spreadsheet cell that’s displaying a formula.

You might see Text in the format drop-down menu shown in the snapshot directly below. Select General on the drop-down menu. Then the cell will display calculated output when you click within the formula bar (with the cell selected) and press the Return key.

A Text format cell excel spreadsheet not automatically calculating


4. Check you’ve entered the formulas correctly

Excel won’t automatically calculate formulas when they haven’t been entered correctly. One of the things hardest to spot is a space in the formula just ahead of the equals (=).

When there’s a space right at the beginning of the formula, its cell will display the function instead of a result for it. So, make sure there aren’t any spaces at the start of functions. If the formula contains spaces anywhere else, Excel will display #Name? in its cell.

Ad

An Excel formula excel spreadsheet not automatically calculating

So, that’s how you can fix an Excel spreadsheet that doesn’t automatically calculate its formulas. Thereafter, the spreadsheet’s cells will automatically display the results for formulas as expected.

For any other questions or suggestions, feel free to reach for the comments section below.

RELATED ARTICLES TO CHECK OUT:

Ad
Was this page helpful?
Thanks for letting us know! You can also help us by leaving a review on MyWOT or Trustpillot.
Get the most from your tech with our daily tips
Tell us why!