Excel’s formulas make it one of the most essential MS Office applications. 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

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.

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.

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. 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:

How to fix Excel error: There’s a problem with this formula How to fix corrupted Excel cells in 4 quick steps Microsoft Excel is trying to recover your information error

Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ