If an Excel formula stays stuck on an old value after you change its inputs, the first thing to check is calculation mode. Microsoft says Automatic is the default workbook calculation setting, while Manual calculation requires you to trigger recalculation yourself. In current Excel for Microsoft 365 on Windows and Mac, a stale formula result may even appear with a strikethrough when Manual or Partial calculation is active.
The goal is not simply to make one number change once. A successful fix means a dependent formula updates again when you edit one of its precedent cells, without requiring you to press F9 every time. The three steps below start with the broadest cause, then move to a forced recalculation, and finally to cell-level problems that can make a formula look as if it is not calculating.
Use a small test before making larger changes to your workbook. Pick a formula whose inputs you understand, note its current result, and change one referenced input cell. If calculation is working normally, the formula result should refresh automatically.
| What you see | What it usually suggests | Best next move |
|---|---|---|
| Many formulas stay on old values | Workbook calculation may be Manual or Partial | Start with Step 1 |
| Automatic is already selected, but values still look stale | The workbook may need a fresh calculation pass | Use Step 2 |
| Only one cell or a few cells show the formula text | Show Formulas may be on, or the cells may be formatted as Text | Use Step 3 |
| The cell shows #REF!, #VALUE!, #DIV/0!, or another error | The formula itself has a different problem | Troubleshoot that formula error instead of calculation mode |
In Excel for Windows desktop, open File > Options > Formulas. Under Calculation options, set Workbook Calculation to Automatic, then select OK. You can also reach the calculation choices from the Formulas tab through Calculation Options.
AI-generated illustration: choosing Automatic from Excel Calculation Options. The image is illustrative rather than a captured Microsoft screenshot, and exact labels can vary by Excel build.
On Excel for Mac, Microsoft documents the equivalent path as Excel > Preferences > Calculation, then choose Automatic.
AI-generated illustration: the Excel Options dialog with Automatic workbook calculation selected.
Return to the worksheet and change a value used by a simple formula. For example, if D2 contains =B2*C2, change B2. D2 should update without using Calculate Now or F9.
There is one important desktop behavior to know: Microsoft notes that changing calculation options affects all open workbooks in Excel desktop apps. If you have several workbooks open, verify that switching to Automatic is appropriate for all of them. Large financial models or workbooks with data tables may have been placed in a nonautomatic mode intentionally for performance.
If your workbook is large and Automatic causes long recalculation delays, do not assume the setting itself is broken. You may need a performance-oriented calculation strategy rather than leaving the workbook permanently on Automatic.
If Automatic is already selected, or you just changed it from Manual, trigger one explicit calculation to clear stale results. The most version-independent way is Formulas > Calculate Now.
AI-generated illustration: using Calculate Now to force a workbook recalculation.
On Windows, Microsoft also documents these calculation shortcuts:
Do not judge the fix only because Calculate Now produced the expected number. Change the source value a second time after the calculation completes. If the dependent result now changes automatically, the original issue was likely stale calculation state or Manual calculation. If the result becomes stale again immediately, move to Step 3 or inspect the workbook for a more specific calculation problem.
Excel for Microsoft 365 can help here. Microsoft describes stale value formatting for Manual and Partial calculation modes: a formula result that has not yet been recalculated can appear with a strikethrough. After recalculation completes, that stale formatting is removed. This is a useful signal, but it has limits: Microsoft says external data values and some formulas dependent on Data Table cells do not show stale-value formatting.
If most of the workbook calculates correctly but one cell displays something like =SUM(B2:B10) instead of a result, the problem may not be automatic calculation at all.
Open the Formulas tab and check Show Formulas. On Windows, Ctrl+` toggles this view. When Show Formulas is enabled, Excel intentionally displays formula expressions in worksheet cells instead of their calculated results.
Microsoft recommends changing the affected cell to General format, then editing and re-entering the formula. On Windows, one documented sequence is: right-click the cell, choose Format Cells > General, select the formula cell, press F2, and then press Enter.
If an entire range was imported as text, Microsoft also documents a bulk method: select the range, apply the desired number format, then use Data > Text to Columns > Finish to reapply the values so Excel recognizes them correctly.
AI-generated illustration: a simple verification state in which dependent totals are displaying calculated values again.
Select the repaired cell. The formula bar should still contain the formula, while the worksheet cell should display its calculated result in normal view. Then change a referenced input and confirm that the result follows the change automatically.
The steps above are aimed at the common case where valid formulas are not refreshing automatically. They are not a universal repair for every Excel calculation problem. Change your troubleshooting approach when the evidence points elsewhere.
Avoid replacing formulas with their current values just to make the sheet “look right.” Microsoft warns that replacing a formula with its result makes the result static. That can be useful intentionally, but it removes future recalculation behavior.
Also avoid turning on iterative calculation as a general fix. Iteration is designed for formulas that intentionally contain circular references. Enabling it can make a workbook appear to calculate while masking a modeling mistake.
Finally, do not rely on a single press of F9 as proof that Automatic mode is restored. The better test is behavioral: modify a precedent cell and verify that its dependent formulas update again without manual intervention.
If a simple input-change test now updates the dependent formula immediately, the workbook is behaving as expected. If not, the next step should be targeted diagnosis—circular references, formula errors, external data, or workbook performance—rather than repeating the same calculation toggle.
Use this simple Word task delegation matrix template to assign owners, clarify approvals, track due dates, and reduce confusion across a small team.
Reduce hallucinations in enterprise RAG agents by tracing failures, improving retrieval and permissions, adding grounded answer and action controls, and evaluating retrieval, citations, abstention, and tool use.
Fix missing audio in PowerPoint screen recordings by checking recording audio, Windows microphone access, input devices, playback, updates, and repair options.
Fix Excel formulas that are not calculating automatically in three steps: enable Automatic calculation, force a recalc, and repair formula cells.
Build a private local PDF extraction pipeline with PyMuPDF, OCRmyPDF/Tesseract, Docling, and Ollama structured outputs. Compare speed, layout fidelity, hardware needs, and validation tradeoffs.
Use this simple printable daycare attendance sheet for home childcare, with practical fields for arrival, departure, absences, totals, and record checks—plus guidance on when a basic paper log is not enough.
Fix LangChain agent memory loss in long conversations with thread-scoped checkpointers, stable thread IDs, summarization, persistent stores, and practical tests.
Fix blurry or garbled Midjourney text with verified prompt techniques: double quotes, shorter copy, Raw, lower Stylize, and targeted Editor repairs.
Use this free Agile project status report presentation template to summarize goals, completed work, risks, metrics, decisions, and next steps without turning Scrum into a status meeting.
【New Intelligence Introduction】 AI Agents are a hot topic in the field of large models. Users can introduce multiple LLM Agents with different roles to participate in actual tasks. Agents will engage in various forms of dynamic interactions such as competition and collaboration, thereby producing amazing group intelligence effects. This article introduces the large model mind interaction CAMEL framework (Camel) from the KAUST research team. The CAMEL framework is the earliest well-known project of autonomous agents based on ChatGPT, and has been accepted by the top artificial intelligence conference NeurIPS 2023.
