If Excel formulas are not updating when you change the numbers they depend on, check the calculation mode first. In most cases where many formulas are stuck at old values, the fastest fix is Formulas > Calculation Options > Automatic. Microsoft identifies Automatic as Excel's default calculation setting; Manual calculation tells Excel to wait until you explicitly recalculate.
That quick fix is appropriate when a workbook was previously calculating normally and now several totals, percentages, lookups, or other dependent formulas stay unchanged after you edit source cells. If only one formula is misbehaving, or the cell literally displays something such as =B2*C2 instead of a result, skip ahead to Step 3 because the problem may be the cell itself rather than the workbook calculation mode.
Excel has multiple calculation modes. In Automatic mode, dependent formulas recalculate when relevant values, formulas, or names change. In Manual mode, Excel waits for a manual calculation command. Microsoft also provides a mode that excludes data tables from normal automatic recalculation, which can matter in workbooks that use What-If Analysis data tables.
On Excel desktop for Windows, Microsoft notes that changing calculation options affects all open workbooks. In Excel for the web, the calculation option applies to the current workbook instead. This difference matters when a workbook seems to inherit unexpected behavior during a desktop session.
There is another class of problem that looks similar but is not a calculation-mode issue. A formula may be stored as text, the worksheet may have Show Formulas turned on, a formula may have been overwritten with a fixed value, or the formula may contain an error. The three-step process below separates those cases instead of treating every symptom as the same problem.
Start here if several formulas fail to update after you change their input cells.
You can also reach the setting in Excel for Windows through File > Options > Formulas, then look under Calculation options and Workbook Calculation. Microsoft's current documentation describes Automatic as the setting that recalculates dependent formulas whenever a relevant value, formula, or name changes.
Example: suppose cell D2 contains =B2*C2. B2 is the quantity and C2 is the unit price. If B2 changes from 10 to 12, D2 should update without requiring another action when Automatic calculation is working normally.
When this step is likely to solve the problem: many formula results are stale, pressing F9 updates them, or a workbook that used to calculate immediately now waits for manual intervention.
When it may not be enough: only one cell is affected, the formula itself is visible as text, the cell shows an Excel error such as #VALUE! or #REF!, or the result depends on an external workbook or data connection that has not refreshed.
For Microsoft's full explanation of the available calculation modes and their scope, see Microsoft Support: change formula recalculation, iteration, or precision in Excel.
After switching to Automatic, force one clean recalculation. This is useful because a workbook may contain values that were calculated while Manual mode was active.
On the Formulas tab, select Calculate Now. Microsoft also documents these useful keyboard options:
For a normal workbook, start with Calculate Now or F9. Use Ctrl+Alt+F9 when ordinary recalculation does not refresh a workbook that should be fully formula-driven. The dependency-rebuild shortcut is more of a troubleshooting tool than a routine command.
Now perform a simple test. Change one obvious input used by a formula. For example, if =B2*C2 currently returns $150 from a quantity of 10 and a unit price of $15, change B2 to 12. In Automatic mode the result should become $180 immediately.
If that happens, the calculation engine is working again. If F9 changes the result but a later edit does not, recheck Step 1 because the workbook or desktop session may still be in a nonautomatic mode. If nothing changes at all, move to Step 3.
If most formulas work but one or a few do not, inspect those cells directly. Microsoft lists two especially common causes when a formula shows its syntax instead of a calculated value: Show Formulas may be enabled, or the cell may be formatted as Text.
First open the Formulas tab and check Show Formulas. If it is on, turn it off. The keyboard shortcut Ctrl+` toggles that view.
If the formula still appears as text, select the affected cell and change its number format from Text to General. Microsoft then recommends pressing F2 followed by Enter so Excel re-enters the content as a formula. Simply changing the displayed number format may not convert an already-entered text formula by itself.
Click the cell and inspect the formula bar. Confirm the content actually begins with = and still contains the intended formula. A formula can be accidentally replaced by a pasted value, which means there is nothing left for Excel to recalculate.
If the cell shows an error such as #VALUE!, #REF!, or #NAME?, automatic calculation is probably functioning; the formula or its inputs need repair. A text value where a number is expected, a deleted reference, or a misspelled function can all produce errors even when calculation mode is correct.
Microsoft's troubleshooting page provides the official procedures for both Show Formulas and cells formatted as Text: Microsoft Support: how to avoid broken formulas in Excel.
Do not stop after seeing the current result change once. Verify automatic behavior with a controlled edit:
If the formula updates immediately, the original “Excel formula not calculating automatically” problem is resolved for that workbook path. In newer Microsoft 365 builds, Microsoft may also mark a formula result as stale when underlying data has changed but recalculation has not yet occurred, especially in Manual or Partial calculation modes. A stale indicator is a clue that the displayed value should not yet be treated as current. See Microsoft Support: stale value formatting for the current behavior.
At that point, the problem may not be automatic calculation itself. Check the conditions around the formula.
| Symptom | Most useful first action |
|---|---|
| Many formulas stay at old values | Set Calculation Options to Automatic |
| F9 updates the numbers | Recheck calculation mode; Manual mode is a strong clue |
| One cell displays =SUM(...) or another formula literally | Turn off Show Formulas and check whether the cell is formatted as Text |
| One cell shows #VALUE!, #REF!, or #NAME? | Repair the formula or its inputs |
| Worksheet formulas update but linked data remains old | Check the external link or data refresh process |
| Only What-If data tables seem stale | Check whether calculation is set to exclude data tables |
For the common case, the solution is straightforward: 1) set Formulas > Calculation Options > Automatic; 2) run Calculate Now or press F9 once; 3) if individual cells still fail, check Show Formulas, Text formatting, and the formula itself.
The important distinction is scope. A workbook-wide failure points first to calculation mode. A single-cell failure points first to the formula or cell formatting. Using that distinction prevents unnecessary troubleshooting and makes it easier to tell whether Excel's calculation engine is actually the problem.
Use this simple task delegation matrix template in Word to assign owners, decision limits, deadlines, and checkpoints without overcomplicating a small team.
Use this simple printable daycare attendance sheet for home childcare, with child names, arrival/departure times, signatures, and compliance tips.
Use this printable one-page marketing strategy template to define your local audience, offer, channels, budget, weekly actions, and measurable goals.
Stop Excel from converting values like 1/2, 11-53, or JAN1 into dates. Learn reliable fixes for typing, pasting, CSV imports, and already-converted cells.
Build a practical Excel equipment maintenance log for a workshop: track service history, due dates, meter readings, downtime, costs, and follow-up without overcomplicating the sheet.
Build a polished real estate listing PowerPoint for free with a practical slide plan, photo, branding, accessibility, compliance, and export tips.
Fix Outlook when you can receive email but cannot send. Check Outbox, offline mode, sign-in, SMTP settings, profiles, and Microsoft 365 changes.
Build a simple bi-weekly payroll tracker in Excel for a small team, with hours, pay, deductions, review flags, summaries, and recordkeeping guidance.
Build or customize a printable event planning checklist and budget template in Microsoft Word, with practical sections, tradeoffs, and tips for Word vs. Excel.
Build a simple new-hire onboarding presentation with a practical 12-slide structure covering role expectations, tools, security, policies, safety, and first-week actions.
