It’s 3:12 PM on a Tuesday. You’re updating the Q2 sales dashboard for Acme Corp when cell D7 suddenly shows #N/A, then E8 stays at 0 even after you paste new numbers into B2:B15. You restart Excel. Then Windows. Then your laptop. Still nothing updates. Your teammate leans over: ‘Is Excel working today?’ — and you realize nobody’s actually checked whether it’s *supposed* to be calculating.
The Setup
You’re tracking weekly client renewals for a small SaaS team. Data comes from three sources: a CRM export (copied into Sheet1), a finance CSV (pasted into Sheet2), and manual entries in Sheet3. You’ve built a summary tab (‘Dashboard’) that pulls from all three using formulas like =SUMIFS(Sheet2!C:C,Sheet2!A:A,Dashboard!A2). But this morning, the totals haven’t changed — even though Sarah Chen renewed her plan yesterday.
| Client | Contract End | Renewal Status | Amount ($) |
|---|---|---|---|
| Alpha Dynamics | 2024-06-15 | Active | $28,500 |
| Bloom Labs | 2024-07-03 | Pending | $19,200 |
| Cedar Group | 2024-05-22 | Expired | $0 |
| Daxton Inc | 2024-08-11 | Active | $41,750 |
| Eclipse Media | 2024-06-30 | Active | $33,100 |
| Finn & Rowe | 2024-07-18 | Pending | $14,900 |
| Grove Systems | 2024-05-29 | Expired | $0 |
| Haven Analytics | 2024-08-05 | Active | $52,300 |
| Inkwell Co | 2024-06-12 | Active | $22,600 |
| Jasper Holdings | 2024-07-25 | Pending | $17,400 |
The Challenge
You think Excel is ‘broken’ because formulas aren’t updating — but what if Excel isn’t broken at all? What if it’s just set to manual calculation mode? That’s the single most common reason people ask ‘Is Excel working today?’ It’s silent, invisible, and doesn’t throw an error. You’ll see =NOW() stuck on yesterday’s date. A SUM() won’t reflect new values in A1:A10 unless you hit F9. And worse — it’s easy to toggle accidentally (Alt+M+X, then M). (Trust me, I learned this the hard way during a live board demo.)
Other layers add confusion: external links may be broken, volatile functions like TODAY() behave differently in manual mode, and auto-recalc can be disabled per-workbook — not just globally.
Walking Through It
We’ll test and fix recalculation in four clear steps. Open your file and follow along.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | Click Formulas → Calculation Options | Dropdown shows current mode (likely Manual) | Alt+M+X |
| 2 | Select Automatic from the dropdown | All formulas update instantly — including those referencing Sheet2!C:C | (No shortcut — click only) |
| 3 | Test with =NOW() in cell Z1 | Time updates every second — proof recalc is live | Ctrl+; for static date, Ctrl+Shift+; for static time |
| 4 | Force full recalc: Formulas → Calculate Now | Even cached volatile functions refresh across all sheets | F9 |
If Step 1 shows Automatic but formulas still don’t update — look deeper. Check for circular references (Status Bar says ‘Circular References: A5’). Or open File → Options → Formulas and verify ‘Enable iterative calculation’ is off unless you truly need it. (Spoiler: 97% of users don’t.)
The Result
After switching to Automatic and pressing F9, your Dashboard now reflects real-time changes. Sarah Chen’s $24,800 renewal appears in the ‘Active’ total — no rewrites, no macros, no IT ticket.
| Metric | Value | Last Updated |
|---|---|---|
| Total Active Contracts | 7 | 2024-06-18 15:23 |
| Q2 Renewal Value | $182,150 | 2024-06-18 15:23 |
| Pending Approvals | 3 | 2024-06-18 15:23 |
| Expired This Month | 2 | 2024-06-18 15:23 |
| Avg Contract Size | $32,400 | 2024-06-18 15:23 |
What Could Go Wrong
Three specific missteps cause people to keep asking ‘Is Excel working today?’ — even after fixing calculation mode:
- Mistake #1: Forgetting external links are broken. If your Dashboard pulls from
'[Finance-Q2.xlsx]Summary'!B5, and Finance-Q2.xlsx is closed or moved, Excel halts recalc until that link resolves. You’ll see#REF!or stale values — not an error message. Fix: Data → Edit Links → Update Values (Alt+A+L+U). - Mistake #2: Using
INDIRECT()with closed workbooks. UnlikeVLOOKUP,INDIRECT()fails silently when referencing a closed file. Your formula returns#REF!, but you might miss it if it’s buried in column H. Test by temporarily opening the source file — if values appear,INDIRECTis your culprit. - Mistake #3: Accidentally enabling ‘Manual’ for just one workbook. Excel remembers calculation mode per-file. So Workbook A could be Manual while Workbook B is Automatic — and you’d never know unless you check each one. Always verify before pasting critical data.
Here’s your quick-reference checklist before panicking:
| Check | How | Shortcut |
|---|---|---|
| Recalc mode | Formulas tab → Calculation Options | Alt+M+X |
| Circular references | Look at bottom-left Status Bar | None |
| External links | Data tab → Edit Links | Alt+A+L |
| Volatility test | Enter =NOW() in any empty cell | Ctrl+Shift+; (static time) |
