If an Office 365 Excel formula is not calculating, first check Formulas > Calculation Options and select Automatic. If the result still does not update, check whether the cell is formatted as Text, whether Excel is displaying formulas instead of results, and whether the formula or its referenced cells contain an error.
What “not calculating” can mean
People use “not calculating” to describe several different symptoms. A cell might show an old answer after its inputs change, display the formula characters instead of a result, remain blank, or show an error such as #VALUE!. The cause differs, so note exactly what appears in the cell before changing settings.
Excel normally recalculates formulas when their inputs change. A formula is an instruction stored in a cell; Excel evaluates it and displays the result. If an input changes but the displayed answer stays the same, calculation may be set to Manual. If the formula itself appears in the grid, the cell may be treated as text or Show Formulas may be on. An error value usually means Excel did calculate, but the formula encountered a problem.
For example, with the numbers 10, 20, and 30 in cells B2:B4 and a formula in B5, the formula =SUM(B2:B4) should return 60. If B5 shows the characters =SUM(B2:B4), investigate display and formatting settings. If B5 shows an old total after one of the inputs changes, investigate calculation mode.
Check the workbook’s calculation mode
In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and choose Automatic. You can also use File > Options > Formulas and select Automatic under Workbook Calculation. In Manual mode, Excel waits for a calculation command instead of updating every dependent formula as you edit. This can make a workbook look frozen even though its formulas are intact.
After choosing Automatic, press F9 to recalculate. If only the active worksheet needs an update, Shift+F9 calculates that sheet. On some keyboards you may need to hold Fn to use F9; laptop function-key settings vary. On Mac, use Formulas > Calculation Options if available, or open Excel > Settings (called Preferences in some versions) and look for Calculation. The exact settings layout can vary by Excel release.
Excel’s calculation mode can affect other workbooks open in the same Excel session, so a workbook opened earlier may help explain why a setting seems unexpected. If the mode keeps changing, save your work, close other workbooks, reopen the affected file, and check the setting again. Do not switch to Manual simply to make a large workbook feel faster unless you are prepared to recalculate deliberately: otherwise displayed totals can remain out of date.
- Automatic: Excel recalculates dependent formulas when their inputs change.
- Automatic Except for Data Tables: Excel updates ordinary formulas automatically but does not automatically recalculate What-If Analysis data tables.
- Manual: Excel waits for a command such as F9, which can leave visible results stale.
Check whether the formula is stored as text
If a cell displays an expression beginning with an equals sign instead of its answer, select the cell and inspect the Home > Number Format list. A cell formatted as Text treats new entries as text, so typing a formula into it may not start a calculation. Change the format to General, then re-enter the formula. Merely changing the number format may not convert an existing text entry into a working formula.
To re-enter it, select the cell, press F2, then press Enter. Alternatively, click in the formula bar and press Enter. If the cell starts with an apostrophe, such as ‘ =SUM(B2:B4) without the space, remove the apostrophe and re-enter the formula. An apostrophe is sometimes used to force text, and it is not part of the calculation.
Also check for an accidental space before the equals sign. A formula must begin with = as the first character in the cell entry. A leading space can cause Excel to read the entry as text. If several cells are affected, select the range, set its format to General, and re-enter each formula; changing the format alone does not guarantee that previously entered text will be parsed again.
For a simple test, with 2 in A1 and 3 in A2, enter =A1+A2 in A3 after confirming that A3 is set to General. The expected result is 5. If the formula text remains visible, check Show Formulas and the leading characters before assuming the arithmetic is wrong.
Turn off Show Formulas if formulas fill the grid
If many cells show expressions rather than answers, the worksheet may be in Show Formulas mode. On Windows, press Ctrl+` (the grave-accent key, often beside 1 or below Esc) to toggle the view, or use Formulas > Show Formulas. On Mac, the shortcut may depend on the keyboard layout; use the Show Formulas command on the Formulas tab if the shortcut does not work.
Show Formulas is a display setting, not a calculation failure: the formulas remain in their cells, and switching back shows their calculated results. Column widths often expand while formulas are displayed, which can make the change look dramatic. If just one cell shows formula text while the rest of the sheet displays answers, cell formatting or a leading apostrophe is more likely than Show Formulas.
Inspect the formula and the cells it depends on
A formula can calculate correctly and still produce an unexpected result because its references are wrong. Select the cell and read the formula bar. Check that it points to the intended rows, columns, and worksheet. When you copy a formula, relative references shift; references with dollar signs stay fixed. For example, if a copied formula should always use a tax rate in B1, the reference needs to be locked as $B$1. A misplaced reference may return a plausible but incorrect number rather than an obvious error.
With quantities in A2:A4 and unit prices in B2:B4, put this formula in C2 and fill it down: =A2*B2. If A2 contains 3 and B2 contains 12, C2 should show 36. If it shows 0 or an error, confirm that the inputs are in the cells the formula references and that the values are usable numbers. A number stored as text can cause unexpected results in arithmetic or comparisons.
When a formula returns an error, follow the error rather than treating it as a recalculation setting. #DIV/0! commonly means a division formula has a zero or blank denominator; #REF! means a reference is invalid, often because a referenced cell or sheet was deleted; and #NAME? can indicate an unrecognized function or misspelled name. #VALUE! often points to an argument or input of an unexpected type. Correct the source issue, then check the result again.
Recalculate and trace the affected cells
Once calculation is Automatic, force a fresh calculation with F9. If the result still looks wrong, confirm that the input cell actually changed and that the formula refers to it. Click the result cell and use Formulas > Trace Precedents to show cells feeding into the formula, or Formulas > Trace Dependents to see which formulas rely on the selected cell. These arrows can reveal that a formula points to a neighboring row or an unexpected worksheet.
For a workbook with many formulas, calculate in stages. First check a small formula in a blank cell, then check one affected formula and its inputs, and finally recalculate the workbook. This helps distinguish a workbook-wide setting from a single broken reference. If a formula is intentionally dependent on a value that has not changed, an unchanged result may be correct; recalculation cannot make an incorrect formula correct.
Some functions depend on changing conditions such as the current date, a random value, or external data. They may update at different times or when the workbook recalculates, depending on the function and connection. If only one result is stale, compare its dependencies and data source with a working formula before changing calculation settings for the whole file.
Look for circular references and external data issues
A circular reference occurs when a formula refers to its own cell, directly or through a chain of other formulas. For instance, a total in A1 that includes A1 itself cannot be evaluated as an ordinary formula. Excel may display a circular-reference warning or identify the location under Formulas > Error Checking > Circular References. Remove the unintended loop. Iterative calculation can be enabled for deliberate models that require it, but it should not be used as a general repair because it changes how Excel resolves those formulas.
Formulas linked to another workbook may depend on that file’s location, access, or latest saved values. If a linked result is stale, open the source workbook if possible and review the link update prompt or the workbook’s link settings. Do not assume a formula error means the source file is available or that its values are current. For imported data, refresh the relevant connection or query using its refresh command, then confirm the refresh completed before judging dependent formulas.
Excel for the web and Mac differences
The steps above primarily describe Microsoft 365 Excel for Windows. Excel for the web also recalculates ordinary formulas, but its ribbon and settings can differ from the desktop application. If the web workbook appears stale, check the Formulas tab for calculation options where available, verify the formula and cell format, and refresh the browser page only after confirming the workbook has saved. Opening the file in desktop Excel can help when you need desktop-specific settings or detailed diagnostics.
On Mac, formula behavior is broadly similar, but settings are accessed through the Excel menu or the ribbon depending on the release, and function-key shortcuts can require Fn. Excel also uses regional list separators: a computer configured for a locale that uses semicolons may expect semicolons between function arguments when users enter formulas. If a formula is rejected rather than calculated, check the separator expected by that installation; the examples here use commas.
Frequently Asked Questions
Why does Excel show the formula instead of the answer?
Check whether Show Formulas is on. If other cells show results normally, set the affected cell to General, remove any leading apostrophe or space, and re-enter the formula.
Why does my Excel formula update only when I press F9?
The workbook is likely using Manual calculation. Choose Formulas > Calculation Options > Automatic, then press F9 once to refresh existing results.
Will changing a cell from Text to General fix an existing formula?
Not necessarily. After changing the format, re-enter the cell content by pressing F2 and Enter, or edit it in the formula bar and press Enter. Excel needs to parse the entry again.
Why does my formula return zero when the input cells contain numbers?
Check that the formula refers to the cells you mean, and confirm the inputs are actual numbers rather than text that looks numeric. Also inspect whether the referenced cells are blank or whether a condition in the formula excludes the values.
Does Excel for the web use the same fixes?
The core checks—formula text, cell format, references, and calculation settings—still apply. The ribbon and available controls may differ from Windows desktop Excel, so use the web Formulas tab or open the workbook in desktop Excel for settings that are not available in your browser.
Related
- How to Partially Protect an Excel Sheet
- How to Print Just a Highlighted Area in Excel
- How to Merge Cells in Excel Without Losing Data Safely
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Too Many Arguments Error: Causes, Fixes, and ExamplesExcel’s “You’ve entered too many arguments for this function” message means a formula supplies more inputs than that…
- Excel Formula Bar Not Working? Fixes to TryIf Excel’s formula bar is not working, first turn it back on by choosing View > Show >…
- Where to Find an Excel File After a Crash on WindowsAfter Excel crashes on Windows, reopen Excel and check the Document Recovery pane first; open the newest recovered…
- Why Is My TRANSPOSE Formula Not Working in Excel?Your Excel TRANSPOSE formula usually fails because its result cannot fit in the destination, it was entered using…
- Excel Not Enough Memory Error: Causes and Fixes ExplainedIf Excel says there is not enough memory to complete an action, first save your work if possible,…
- Excel Table Heat Maps: Create, Customize, and Fix ThemAn Excel table heat map uses Conditional Formatting to color cells according to their values, making high, low,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.