Excel · ChatGPT
Excel Formula Not Calculating? Fix 3 Common Causes
A valid formula can keep showing an old result because Excel is not recalculating, an external link is stale, or the formula depends on its own total cell. Choose the symptom that matches your workbook and use the tested prompt to diagnose it safely.
Choose your situation — copy the prompt:
I am working in Q3-orders.xlsx on the Orders worksheet. These are the current cells: B2 (Units): 15, recently changed from 12 C2 (Unit price): 19.50 D2 (Line total): =B2*C2, currently displaying 292.50 B3 (Units): 8 C3 (Unit price): 45.00, recently changed from 42.00 D3 (Line total): =B3*C3, currently displaying 336.00 B4 (Units): 5 C4 (Unit price): 10.00 D4 (Line total): =B4*C4, currently displaying 50.00 D5 (Total): =SUM(D2:D4), currently displaying 678.50 Before the edits, D2 was 234.00, D3 was 336.00, D4 was 50.00, and D5 was 620.00. After B2 changed from 12 to 15, D2 and D5 did not update. Formulas > Calculate Now changed D2 to 292.50 and D5 to 678.50. I then changed C3 from 42.00 to 45.00, but D3 remained 336.00 and D5 remained 678.50. The formulas are present normally, Show Formulas is off, the formula cells are not formatted as Text, and Calculation Options shows Manual. Please diagnose the cause, explain how to restore Automatic calculation safely, recalculate the stale results, and state the verified final values for D2, D3, D4, and D5. Mention that calculation mode may affect other open workbooks, distinguish Windows and Mac menu differences where relevant, and preserve all formulas and source data.
Use when several formulas remain unchanged after their inputs change.
I have an Excel workbook named Invoice Summary.xlsx with this data: - B2 contains the invoice amount: 1000 - C2 contains: =B2*'[Exchange Rates.xlsx]Rates'!$B$2 Yesterday, Rates!B2 in Exchange Rates.xlsx was 1.08, so C2 returned 1080. Today the source workbook was updated and saved with Rates!B2 equal to 1.10, but Invoice Summary.xlsx still displays 1080. Calculation is Automatic. The formula is present normally, F9 does not change the result, there is no circular-reference warning, both files exist in their expected locations, and Excel may display a security or workbook-links notice. Why is the formula returning the old result? Give safe, non-destructive steps to update the linked value, explain why ordinary recalculation may not be enough, state the expected result, and account for differences in workbook-link controls across Excel versions, Windows, and Mac. Do not break the link or replace the formula with a fixed value.
Use when a formula depends on a value saved in another workbook.
I am working on the August Sales worksheet with these cells: A1: Representative B1: Sales A2: Elena B2: 1250.50 A3: Marcus B3: 980.00 A4: Priya B4: 1325.25 A5: Total B5: =SUM(B2:B5) The expected total is 3555.75, but B5 does not calculate correctly and Excel identifies B5 as a circular reference. Calculation mode is Automatic, iterative calculation is disabled, and there are no external links, macros, or protected cells. Please diagnose the direct circular reference, preserve B2:B4, provide the corrected formula for B5, state the expected result, explain whether iterative calculation should be enabled, and mention any relevant Windows, Mac, or Excel-version limitation.
Use when a total cell accidentally includes itself in its own range. For indirect loops, chains across multiple cells, running totals, or iterative calculation, see Fix Circular References in Excel.
Before — Manual mode leaves D3 and D5 stale
| Cell | Value or formula | Displayed |
|---|---|---|
| B2 | 15 | 15 |
| C2 | 19.50 | 19.50 |
| D2 | =B2*C2 | 292.50 |
| B3 | 8 | 8 |
| C3 | 45.00 | 45.00 |
| D3 | =B3*C3 | 336.00 |
| D4 | =B4*C4 | 50.00 |
| D5 | =SUM(D2:D4) | 678.50 |
Q3-orders.xlsx · Orders · Calculation Options: Manual. C3 changed from 42.00 to 45.00 after the previous Calculate Now.
→
After — Automatic mode recalculates verified totals
| Cell | Formula | Result |
|---|---|---|
| D2 | =B2*C2 | 292.50 |
| D3 | =B3*C3 | 360.00 |
| D4 | =B4*C4 | 50.00 |
| D5 | =SUM(D2:D4) | 702.50 |
Restore Automatic calculation, recalculate stale results, and preserve every formula and source value.
Before — cached linked value
| Workbook | Cell / status | Value |
|---|---|---|
| Exchange Rates.xlsx | Rates!B2 — saved source | 1.10 |
| Invoice Summary.xlsx | Cached linked rate | 1.08 |
| Invoice Summary.xlsx | C2 result | 1080 |
| Link status | — | Not updated |
F9 can recalculate with the cached 1.08 without retrieving the newly saved source value.
→
After — trusted workbook link updated
| Check | Result |
|---|---|
| Source path | Verified |
| Linked rate | 1.10 |
| Formula | =B2*'[Exchange Rates.xlsx]Rates'!$B$2 |
| C2 | 1100 |
Update the trusted link; do not use Break Link, which replaces the formula with a value.
Before — B5 includes itself
| Representative | Sales |
|---|---|
| Elena | 1250.50 |
| Marcus | 980.00 |
| Priya | 1325.25 |
| Total | =SUM(B2:B5) |
=SUM(B2:B5) → circular reference because the formula in B5 includes B5.
→
After — B5 sums only source values
| Representative | Sales |
|---|---|
| Elena | 1250.50 |
| Marcus | 980.00 |
| Priya | 1325.25 |
| Total | 3555.75 |
=SUM(B2:B4) → 3555.75. B2:B4 remain unchanged; iterative calculation stays disabled.
Diagnose the symptom before changing the formula
Many formulas stay old
Changed inputs do not update dependent cells
Check mode
Only linked data is stale
Source workbook has a newer saved value
Update link
Excel reports a loop
Total range includes the total cell
Fix range
How to fix an Excel formula that is not calculating
A safe five-step check
1
Confirm the symptom
Check whether many formulas are stale, only an external link is stale, or Excel explicitly reports a circular reference.
2
Inspect calculation mode
Use Excel's calculation options to check for Manual mode. Switch to Automatic when that matches the workbook's intended behavior, then recalculate and test an input.
3
Verify external sources
For a linked formula, confirm the saved source value and stored path. Permit and update only a source you trust. Control names vary by Excel version and platform.
4
Check the formula's range
If Excel reports a circular reference, make sure a total formula does not include its own cell. End the range on the preceding data row.
5
Verify without destroying formulas
Confirm the result responds correctly, the link remains intact, and Excel no longer lists a circular reference.
Avoid destructive shortcuts. Do not break an external link merely to refresh it, and do not enable iterative calculation to hide an accidental self-reference.
Frequently asked questions
Why is my Excel formula not calculating automatically?
The workbook may be in Manual calculation mode. Check the calculation options, switch to Automatic when appropriate, and recalculate. Remember that calculation mode can be influenced by the first workbook opened in an Excel session.
Why does F9 not update a formula linked to another workbook?
F9 recalculates with values currently available to Excel, but it does not necessarily retrieve a new value from a closed external workbook. Verify the trusted source and update the workbook link through Excel's external-link controls.
Why does a SUM formula cause a circular reference?
If a total formula includes its own cell in the SUM range, the result depends on itself. Edit the range so it ends at the row above the total cell.
Should I use Break Link to update a stale Excel formula?
No. Break Link replaces the external-link formula with its current value. Verify the source path and update the trusted link instead.
Will Show Formulas mode stop Excel from calculating?
Show Formulas changes how formulas are displayed, not whether they calculate. If formulas are visible instead of results, diagnose that display issue separately from calculation failures.