Most IT help desks tell users to ‘restart Excel’ when something goes wrong. That’s like diagnosing a car’s check-engine light by turning the ignition off and on again. If you’ve ever sat staring at a frozen status bar while Excel eats 92% of your CPU, you already know: restarting doesn’t fix the root issue. It just delays the real diagnosis.
The Problem
‘Why is Excel not working?’ isn’t one question — it’s five different symptoms masquerading as one. And most people misdiagnose the first one they see. Below is a real troubleshooting log from an accounts payable team at Veridian Logistics last Tuesday. Notice how the same symptom (a blank cell where a formula should appear) had three unrelated causes across just six files:
| Symptom | Cause | Fix |
|---|---|---|
A1 shows #VALUE! after pasting data from SAP |
Text-formatted numbers in column B (B2:B27), causing SUM(B2:B27) to fail | Select B2:B27 → Alt + H + F + M → choose 'Number' |
| File opens but hangs for 45+ seconds | Linked external workbook ("Q3_Sales_Report.xlsx") missing from network drive Z:\Reports\ | Data → Edit Links → Break Link (or update path) |
| Formula bar stays blank even when cell has content | View → Show → Formula Bar is unchecked (yes, really) | Alt + W + V + F → toggle Formula Bar on |
| PivotTable refresh fails with 'data source error' | Source range (Sheet2!A1:D105) now includes a blank row at A57, breaking contiguous range detection | Delete row 57 → right-click PivotTable → Refresh |
| AutoFill stops after 3 cells | Cell C4 contains "Q1 2024" but C5 is manually typed "Q2 2024" — Excel sees no pattern | Clear C5:C10 → select C4:C5 → drag fill handle down |
The Solution
Here’s what actually works — not theory, but what I used yesterday to get Maya from Procurement unblocked in 97 seconds:
- Check calculation mode first. Go to Formulas → Calculation Options → make sure it says Automatic. If it says Manual, Excel won’t recalculate formulas until you press F9 — which explains why =SUM(A1:A10) returns 0 even when numbers are there. This setting survives file closes and gets toggled accidentally during macro runs.
- Disable add-ins one-by-one. File → Options → Add-ins → Manage: COM Add-ins → Go… Uncheck everything. Restart Excel. If it works, re-enable one at a time. Last week, a ‘PDF Export Pro’ add-in froze Excel every time someone clicked Print Preview.
- Test with a clean startup. Hold Ctrl while launching Excel. You’ll see “Safe Mode” in the title bar. Open your file there. If it loads fine, the problem is in your personal.xlsb, startup folder, or template — not the file itself.
- Force a full recalculation. Press Ctrl + Alt + F9. Not F9. Not Shift+F9. Ctrl+Alt+F9 rebuilds all formulas from scratch — critical when Excel’s dependency tree gets corrupted (common after copy-pasting from Power BI or web tables).
After applying these steps to Maya’s file (PO_Reconciliation_Q3_2024.xlsx), here’s what changed:
| Before | After | Cell Reference |
|---|---|---|
| #N/A in D2:D12 | Valid vendor names (e.g., "Acme Corp", "Stellar Dynamics") | D2:D12 |
| Blank status bar, 12-second delay on Save | Status bar shows “Ready”, saves in <1 sec | N/A |
| Formula bar hidden | Visible, showing =VLOOKUP(A2,Suppliers!A:B,2,0) | A1 |
| PivotTable shows “(blank)” in Row Labels | Displays 7 distinct departments (e.g., "Logistics", "Finance", "HR") | PivotTable on Sheet3 |
Going Further
You’ll hit edge cases fast. Here’s what to try next — based on actual logs from our internal support channel:
- If Excel crashes on launch: rename
%APPDATA%\Microsoft\Excel\XLSTARTfolder toXLSTART_OFF— then restart. Corrupted templates live there. - If formulas work in Excel Online but not desktop: disable hardware graphics acceleration. File → Options → Advanced → scroll to Display → uncheck “Disable hardware graphics acceleration”.
- If a specific worksheet freezes only when scrolling: check for merged cells in row 1. Yes — just one merged cell in A1:E1 can break scroll performance in sheets with >10k rows.
- For files that open slowly *only* on one machine: run
excel /safefrom Command Prompt, then open the file. If it’s fast, the issue is user profile corruption — not the file.
Surprising tip: Ctrl + ` (backtick) toggles between formula view and value view. If your sheet looks ‘broken’, hit that key first — sometimes it’s just showing formulas instead of results, and you didn’t realize it.
When NOT to Use This
These fixes won’t help — and might make things worse — in four scenarios:
- Corrupted .xlsx file: If Excel shows “We found a problem with some content…” and offers to recover, don’t skip recovery. Manual fixes won’t help if the ZIP structure inside the file is damaged.
- Shared workbook conflicts: If multiple users edit the same file via OneDrive/SharePoint and see “This workbook is locked”, don’t force-close Excel. Use File → Info → Manage Workbook → Discard Changes instead.
- Macros with broken references: If pressing Alt+F8 shows “No macros available”, but the file clearly contains VBA, the project is locked or references are missing — this requires Visual Basic Editor diagnostics, not quick toggles.
- Outdated Excel version: Excel 2013 or older can’t read dynamic array formulas like SEQUENCE() or FILTER(). The error isn’t “not working” — it’s “not supported.” Upgrade or rewrite.
Keyboard Shortcuts
| Action | Shortcut | Notes |
|---|---|---|
| Toggle Formula Bar | Alt + W + V + F | Works even if ribbon is disabled |
| Full formula recalc | Ctrl + Alt + F9 | Recalculates ALL open workbooks, ignoring dependencies |
| Open Excel in Safe Mode | Ctrl while launching | Hold until splash screen disappears |
| Toggle formula/value view | Ctrl + ` (backtick) | Near Esc key — often overlooked |
| Edit cell directly | F2 | Critical when double-click doesn’t enter edit mode |
