You enter a formula, but Excel shows an old number, prints the formula in the cell, or returns an error instead of the answer. The cause is usually one of five things: calculation mode, formula display, text formatting, syntax, or a workbook/add-in problem. Start with the quick checks below, then move to the deeper fixes only if the same workbook still refuses to calculate.
1. Turn automatic calculation back on
Use this first when formulas worked before but now update only after you edit, save, reopen, or press a shortcut. Manual calculation leaves results sitting in place until Excel is told to recalculate.
- 1.Open File > Options > Formulas.
- 2.Under Calculation options, go to Workbook Calculation.
- 3.Select Automatic.
- 4.Return to the sheet and check the formula result.
The ribbon path does the same job: open Formulas > Calculation Options > Automatic.
2. Force Excel to recalculate now
- 1.Open Formulas.
- 2.In the Calculation group, select Calculate Now to recalculate formulas in open workbooks.
- 3.Select Calculate Sheet to recalculate the active worksheet and any charts or chart sheets linked to it.
Run a recalculation immediately if the workbook is still showing stale values. This is useful in manual or partial calculation mode, and it also clears cells that Excel marks as stale.
You can also use the keyboard. Press F9 to recalculate changed formulas in all open workbooks, Shift + F9 for the active worksheet, Ctrl + Alt + F9 for all formulas in all open workbooks, or Ctrl + Shift + Alt + F9 to check dependent formulas and recalculate all formulas.
When Excel shows stale-value formatting, select the stale cell, click the warning icon, then choose the option to calculate the cell or switch calculation back to automatic.
3. Show results instead of formulas
Sometimes nothing is broken. Excel may simply be set to display formulas in cells instead of their calculated answers. Open Formulas > Show Formulas to toggle back to results. The shortcut is Ctrl + `, using the grave accent key. In Excel for the web, use Formulas > Show Formulas.
4. Convert text entries into formulas
- 1.Select the problem cell.
- 2.Open Home and change the number format to General. Another route is right-clicking the cell, choosing Format Cells, then selecting General.
- 3.Press F2.
- 4.Remove a leading apostrophe if one appears, or add the missing = at the start of the formula.
- 5.Press Enter.
A formula formatted as text will sit in the cell instead of calculating. The same thing happens when the entry starts with an apostrophe or is missing the equals sign.
For a larger range, select the range, apply the correct number format, then choose Data > Text to Columns > Finish in desktop Excel.
5. Correct formula syntax that stops calculation
Fix the formula itself before changing app settings when Excel returns an error. These are the checks Microsoft calls out for broken formulas.
- Start the formula with =.
- Match every opening parenthesis with a closing parenthesis.
- Include every required function argument.
- Put text values inside quotation marks.
- Use * for multiplication instead of x.
- Put sheet names with spaces or nonalphabetic characters inside single quotation marks.
Then use Excel's built-in checker. Select the problem cell, click the Error Checking icon next to it, and choose the relevant command. To scan more broadly, open Formulas > Error Checking.
6. Match the separator Excel expects
Functions can fail when the arguments use the wrong list separator. Excel commonly uses either a comma or a semicolon, depending on the OS locale and Excel settings. Edit the formula and replace the separators with the ones your Excel setup expects, such as changing commas to semicolons or semicolons to commas.
In Excel for the web, you can change the regional format, but only for files stored on Microsoft hosts such as OneDrive or SharePoint, and only with third-party cookies enabled in your browser. Change it from File > Options > Regional Settings. Choose a region from the drop-down, then select Change. You can also use Home > Number Format > More number formats..., choose Date, Time, or Special, set Locale, select Apply this locale as default, then select OK.
7. Remove circular references cleanly
- 1.Open Formulas > Error Checking > Circular References.
- 2.Select each listed cell address.
- 3.Edit the formula so it no longer refers back to itself.
- 4.Use Trace Precedents or Trace Dependents when you need to see which cells feed the formula.
- 5.Repeat until the status bar no longer shows Circular References.
A circular reference means a formula points back to itself, directly or through other cells. Excel flags this separately because recalculation cannot finish normally until the loop is fixed. These steps use the Windows or Mac desktop app; in Excel for the web or the mobile apps, formula-auditing commands can be limited, so open the file in the desktop app to locate and fix the reference.
If the circular formula is intentional, turn on iteration instead of removing it. On Windows, open File > Options > Formulas > Calculation options, select Enable iterative calculation, then set Maximum Iterations and Maximum Change. On Mac, open Excel > Preferences > Calculation and select Use iterative calculation.
8. Refresh links and test add-ins
Formulas that depend on another workbook can show old values or fail when the source link breaks. Open Data > Queries and Connections > Workbook Links. To repair a broken link, choose Link options or More Commands next to the workbook, select Change source, then pick the correct source file. To refresh links, select Refresh All, or choose Link options > Refresh for one link.
If linked workbooks are not the issue, test add-ins. On Windows, hold Ctrl and double-click the Excel shortcut, then select Yes to open Office Safe Mode. You can also press Windows logo key + R, type excel /safe, then select OK. When formulas work in Safe Mode, disable add-ins one at a time.
- 1.For Excel add-ins, open File > Options > Add-ins > Manage > Excel Add-ins > Go, then clear the add-in checkbox.
- 2.For COM add-ins, open File > Options > Add-ins > Manage > COM Add-ins > Go, clear the checkbox, then select OK.
- 3.For Office Add-ins, open Home > Add-ins, right-click the add-in, then choose Remove Add-in.
9. Repair or update Office when every file is affected
Move to the Office installation only when the same formula problem appears across many workbooks and the workbook-level checks are done.
On Windows, open any Microsoft 365 app, create a new document, then go to File > Account > Update Options > Update Now. Select Enable Updates first if that button is shown.
On Mac, open Excel or another Microsoft 365 app, then choose Help > Check for Updates. When Microsoft AutoUpdate opens, select Update or Update All. To keep Office current automatically, select Automatically keep Microsoft apps up to date.
For a Windows 11 repair, right-click Start, open Installed apps, select your Microsoft 365 or Office product, choose the ellipses, then select Modify. On Windows 10, right-click Start, open Apps and Features, select the product, then select Modify. For Click-to-Run installs, choose Online Repair > Repair. Choose Quick Repair when you only want the faster file-replacement repair. For MSI-based installs, select Repair > Continue.
On work or school devices, admin policies can control updates and centrally deployed add-ins. Contact your IT team when add-ins return after removal, Office updates are blocked, or Excel settings keep changing.
Frequently Asked Questions
Why does Excel show my function instead of the answer?
Excel is either showing formulas or treating the cell as text. Turn off Formulas > Show Formulas, then change the cell format to General and press F2 followed by Enter.
Why do Excel formulas update only when I press F9?
Workbook calculation is set to Manual. Change it under File > Options > Formulas > Calculation options > Workbook Calculation > Automatic, or use Formulas > Calculation Options > Automatic.
Can a comma or semicolon make an Excel function fail?
Yes. Excel expects the list separator tied to the OS locale and Excel settings. Edit the function so every argument uses the expected comma or semicolon.
What should I do when Excel shows Circular References?
Open Formulas > Error Checking > Circular References, select each listed cell, and change the formula so it no longer refers back to itself. Keep going until the status bar warning disappears.
