Excel: formulas are not calculated - what to do?
Related Videos: 5 Reasons Why your Excel Formula is Not Calculating (May 2024).
If your formulas are no longer calculated in Excel, this is usually due to incorrect settings. These instructions show you how to set these correctly.
Formulas are not calculated in Excel
- Click on the faulty cell with the mouse or select all affected cells. On the "Start" tab you will find a selection menu in the "Number" category.
- Do not select "Text" here, but the "Standard" option (see picture).
- If that doesn't help, click on the "File" tab in the top left and select the "Options". Now activate the "Automatic" option under the "Formulas" category and close the window with "OK".
- Alternatively, the calculation of formulas can be initiated with the [F9] key.