Excel no longer calculates - how to solve the problem

If Excel no longer calculates the entered formulas correctly, the cause is usually incorrect settings. We will show you in this article how to check whether you have accidentally deactivated the automatic calculation and which other settings you should check.

How to enable automatic calculation in Excel

If Excel no longer calculates, although you have entered a correct formula, this can have several reasons. First, check whether you have accidentally disabled the automatic calculation.

1. To do this, click on the "File" tab in the menu bar and select the "Options" entry at the very bottom.
2. Switch there to the category "Formulas" and set in the area "Calculation options" for the workbook calculation a check mark at the option "Automatic".
3. Confirm the change made now still by clicking on "OK" and the calculation should work again.

Excel: These other tips help when the program no longer calculates

If Excel does not perform any calculations, although the automatic calculation is activated, an error in the formatting can also cause the problem. If you have formatted the cell as text, the formula entered there will not be recognized as such and will not be calculated. To check this, navigate to "Start" > "Number" and select the "Default" option from the drop-down menu. If that doesn't help either, simply perform the calculation manually by pressing the "F9 key" on your keyboard.