Excel Formula Not Calculating Until You Press Enter?

Formulas & functions · Updated November 19, 2026

If an Excel formula updates only after you press Enter, first check whether calculation is set to Automatic: in Microsoft 365 for Windows, go to Formulas > Calculation Options > Automatic. If that setting is already on, check whether the cell is formatted as Text or the formula is being displayed rather than calculated; those are common reasons a formula appears stuck until you edit it.

Why a formula may look stuck

Excel normally recalculates formulas when their inputs change. A formula in a cell is part of a dependency chain: if one of its referenced cells changes, Excel marks the result for recalculation and updates it according to the workbook’s calculation settings. If that update does not happen promptly, pressing Enter while editing a formula can make it seem as though Enter fixed the problem, even when it only triggered a recalculation or corrected how Excel interprets the cell contents.

The symptom can mean different things. The displayed answer might be an old result, the cell might contain formula text instead of a working formula, or Excel might be showing formulas across the sheet. These conditions need different fixes. Before changing formulas or deleting data, identify which one applies: check the calculation setting, inspect the cell’s number format and formula bar, and compare the displayed value with the formula you expect.

Start with these quick checks

Use this short sequence to narrow down the cause without changing the workbook unnecessarily:

  1. Check calculation mode. Select Formulas > Calculation Options and see whether Automatic is selected.
  2. Check whether the formula is visible as text. Click the cell and look at the formula bar. If the cell itself shows something like =A2*B2 instead of a result, look for Text formatting, a leading apostrophe, or Show Formulas mode.
  3. Recalculate once. On Windows, press F9 to calculate open workbooks. If the result changes, the calculation setting or calculation state is a likely lead.
  4. Check the inputs. Confirm that the cells referenced by the formula contain the values you expect and that the formula points to the right cells.

For example, with a price in A2 and a quantity in B2, the formula =A2*B2 should return their product. If A2 contains 12 and B2 contains 3, the expected result is 36. If it still shows 36 after A2 changes to 15, check calculation mode; if the cell displays the characters =A2*B2, investigate text formatting or formula display instead.

Set calculation to Automatic

In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and choose Automatic. You can also open File > Options > Formulas, then select Automatic under Workbook Calculation. Automatic is the usual setting for everyday work: Excel updates dependent formulas as you change their inputs.

If calculation was set to Manual, formulas may retain old results until you request a calculation. Press F9 to calculate formulas in open workbooks, or Shift+F9 to calculate the active worksheet. To force a full calculation, use Ctrl+Alt+F9; to force Excel to rebuild its dependency information as well, use Ctrl+Alt+Shift+F9. These stronger shortcuts are useful for diagnosis, but they do not replace choosing the appropriate calculation mode.

Excel’s calculation mode can affect other workbooks open in the same application session, not just the sheet you are looking at. If you switch it to Manual for a large workbook, check the setting again before working in other files. On Mac, use the Formulas tab’s calculation controls where available, or open Excel > Preferences > Calculation (the wording can vary by release) to inspect calculation settings. Function keys may require the Fn key depending on your Mac’s keyboard settings; the ribbon command is an alternative.

Check for formulas stored as text

A cell formatted as Text can treat an entry beginning with an equals sign as literal text. This often happens when someone formats a column as Text before entering formulas, pastes formula-like content from another source, or begins an entry with an apostrophe. Changing the cell’s number format to General does not necessarily convert an existing text entry into a working formula automatically.

For one affected cell, select it, change its number format to General using Home > Number Format, then press F2 and Enter to re-enter the contents. On Windows, F2 edits the selected cell; on a Mac, use the equivalent edit-cell shortcut for your keyboard or click in the formula bar. The important step is to make Excel interpret the entry again after the format is corrected. If there is a leading apostrophe before the equals sign, remove it as well.

Do not confuse a formula entered as text with a formula that returns text. A working formula can legitimately produce a label or a blank-looking result. Click the cell and inspect the formula bar: a formula should begin with an equals sign there, while a text entry may show a leading apostrophe or be treated as ordinary characters. If many cells are affected, make a copy of the workbook first and test a repair on a small range before applying a bulk conversion.

Make sure Excel is not showing formulas

If many cells display expressions such as =SUM(B2:B6) instead of their answers, Excel may have Show Formulas turned on. This is a worksheet display option; it does not mean every formula has stopped calculating. On Windows, toggle it with Ctrl+` (the grave-accent key, often near the top-left of the keyboard), or use Formulas > Show Formulas. The ribbon command is easier to locate if the keyboard layout makes the shortcut unclear.

Show Formulas can make columns appear wider because formulas take more space than many results. That appearance is a useful clue when the whole sheet seems affected. If only one cell shows its formula, check that cell’s Text format or a leading apostrophe instead. Also verify that the cell is not simply too narrow to display the result: a row of hash marks often indicates a display-width or number-format issue, not a calculation failure. Widening the column can reveal a correctly calculated date or number.

Check references and dependent cells

Sometimes Excel is calculating correctly, but the formula does not refer to the cell that changed. Click the formula cell and inspect its references, or select the formula and use Formulas > Trace Precedents to see cells that feed into it. A copied formula may have shifted a relative reference, while a reference with dollar signs stays fixed when copied. A result that seems stale can therefore be a reference problem rather than a calculation problem.

For a concrete check, with values in B2:B6 equal to 4, 6, 8, 12, and 20, the formula =SUM(B2:B6) should return 50. If you change B2 from 4 to 5 under Automatic calculation, the result should become 51. If it remains 50, check the calculation mode and whether B2 is actually inside the referenced range. If it changes to 51 but your larger workbook still looks wrong, trace the formula’s precedents and verify that the input cells are the ones you intended.

Some formulas depend on values that are themselves produced by other formulas. If an earlier link is broken, formatted as text, or points to an unexpected range, downstream results may also appear wrong. Fixing the first incorrect step in the chain is more reliable than repeatedly pressing Enter in the final result cell.

Less common causes to rule out

External links: A formula that refers to another workbook may show a value based on the last saved state of that source file, or Excel may ask whether to update links. Confirm that the linked workbook is available and review Data > Workbook Links when that control is present. Do not assume that pressing Enter can refresh a missing or inaccessible source file.

Circular references: A circular reference occurs when a formula depends, directly or indirectly, on its own result. Excel may warn about it, and the result can depend on whether iterative calculation is enabled and how its limits are configured. Find the circular reference before changing those settings; enabling iteration is appropriate only when the workbook’s logic is designed to use it.

Data tables and large workbooks: What-If Analysis data tables have calculation behavior and settings that can differ from ordinary formulas. Large models can also take time to recalculate, especially when they contain many dependencies or resource-intensive formulas. Check whether the workbook is still calculating before repeatedly editing formulas, since repeated edits can make diagnosis harder.

Unsupported or invalid formula content: A misspelled function, incorrect reference, or syntax problem normally produces an error rather than a stale answer. Read the error and inspect the formula before treating it as a calculation-mode issue. If the formula uses a function unavailable in the Excel version opening the file, updating Excel or replacing that function may be necessary.

A dependable troubleshooting order

When the cause is not obvious, work from the least disruptive checks to the more specialized ones. This avoids masking a formatting or reference problem with a forced recalculation.

  • Save a copy if the workbook is important, then note which cell and input values demonstrate the issue.
  • Confirm whether one cell or many cells are affected. A whole-sheet display change points toward Show Formulas; isolated cells more often suggest format, entry, or reference issues.
  • Check Formulas > Calculation Options and select Automatic if that is the intended behavior.
  • Inspect the formula bar, cell format, and any leading apostrophe. Re-enter a text-stored formula only after correcting its format.
  • Use F9 or the calculation ribbon control once, then test by changing a referenced input to a known value and checking the expected result.
  • Trace precedents and investigate external links, circular references, or data tables only when the basic checks do not explain the result.

Keep Manual calculation only when there is a clear reason, such as a workbook that takes a long time to recalculate while you make many edits. In that case, calculate deliberately before relying on results, and restore Automatic when appropriate. A displayed number in a manually calculated workbook may be an old result, so treat it cautiously until you have recalculated.

Frequently Asked Questions

Why does my Excel formula update only when I press Enter?
If you mean that editing and re-entering the formula makes it work, check whether the cell was formatted as Text or has a leading apostrophe. If the displayed result is simply out of date, check whether calculation is set to Manual.

How do I make Excel recalculate everything?
On Windows, press Ctrl+Alt+F9 to force a full calculation of open workbooks. Use Ctrl+Alt+Shift+F9 to force Excel to rebuild dependencies as well. You can also use the calculation commands on the Formulas tab.

Why does Excel show the formula instead of the answer?
Check whether Show Formulas is on. If the issue affects only one cell, check whether it is formatted as Text or begins with an apostrophe, then change the format and re-enter the contents.

Does changing Text to General fix a formula that is already entered?
Not always. After changing the format, re-enter the cell contents—select the cell, press F2, then Enter on Windows—so Excel parses the formula again.

Will pressing F9 fix the underlying problem?
It can update a workbook whose calculation was pending or set to Manual, but it will not correct a text-stored formula, a wrong reference, or a broken external link. If the problem returns, identify and fix that underlying cause.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.