It’s 3:12 PM on a Tuesday. You just got an urgent Slack message from finance: 'Can you open Q3_Sales_Forecast_v4.xlsx and update the regional weighting in column G? It’s shared via OneDrive.' You click the link — and land in Excel for the web. Your cursor hovers over cell G12. Nothing happens. No ribbon tab for Developer. No Alt+F8. You stare at the grayed-out ‘Macros’ button and realize: this isn’t Excel. Not really.
Quick Answer
Yes, Office 365 includes Excel — but it ships in four distinct flavors: Excel for the web (free, limited), Excel desktop app (full-featured, requires installation), Excel mobile (iOS/Android, touch-optimized), and Excel in Teams (embedded, read-only by default). Which one you get depends entirely on how you access it — not your subscription level.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Excel for the web (via OneDrive) | Click .xlsx file in OneDrive → opens automatically in browser | Quick edits, sharing with external clients, low-bandwidth environments | No VBA, no Power Query editor, no Solver, no add-ins, no custom number formats beyond basic |
| Excel desktop app (installed) | Launch Excel from Start menu or dock → File → Open → browse OneDrive folder or enter URL | Full functionality: PivotTables with calculated fields, XLOOKUP, dynamic arrays, Power Pivot models | Requires 3–5 GB disk space; auto-updates can break legacy COM add-ins |
| Excel in Microsoft Teams | Open channel → Files tab → click .xlsx → select 'Edit in Teams' or 'Open in Excel' | Real-time co-authoring during standups, quick data validation during calls | No ribbon customization; cannot insert charts from templates; no Quick Analysis tool (Alt+Q) |
| Excel mobile (iOS/Android) | Tap file in OneDrive or Outlook attachment → choose Excel app | Updating status rows on-site, scanning receipts into tables, signing off approvals | No formula bar expansion; cannot edit array formulas; no Data Validation dropdowns on touch |
| Excel via SharePoint Online | Navigate to document library → click file → select 'Edit in Browser' or 'Edit in Desktop App' | Governance-heavy environments (HR, legal), version-controlled templates | Ribbon disappears if site uses custom master page; no support for .xlsm files in browser mode |
Method 1 Deep Dive
Excel for the web — the silent trap. Let’s say you’re reviewing Sales_Q3_2024.xlsx, stored in your team’s OneDrive folder. You open it. Cells A1:E10 show:
| Region | Q3 Forecast ($) | Actual ($) | Variance ($) | Status |
|---|---|---|---|---|
| North America | $1,248,500 | $1,192,300 | -$56,200 | ⚠️ |
| EMEA | $872,100 | $901,400 | +$29,300 | ✅ |
| APAC | $643,800 | $587,200 | -$56,600 | ⚠️ |
| LATAM | $321,900 | $340,100 | +$18,200 | ✅ |
You need to recalculate Variance using =C2-B2 and apply conditional formatting to highlight variances >±$50,000. In Excel for the web, you can type the formula in D2 and drag down — but try selecting D2:D5 and clicking Home → Conditional Formatting → Highlight Cell Rules → Greater Than… You’ll see only two options: ‘Greater Than’ and ‘Less Than’. The full palette? Gone. The ‘Format only cells that contain’ dialog? Not there. And if you try to add a custom formula like =ABS(D2)>50000, the field won’t accept it. That’s the quiet limitation — not missing features, but missing paths to them. The beauty of this approach is speed. The cost? Control.
Method 2 Deep Dive
Excel desktop app — the full orchestra. Now open that same file from the desktop app. Right-click the OneDrive icon in your taskbar → ‘Open folder’ → navigate to \OneDrive - Acme Corp\Finance\Q3 Reports\ → double-click Sales_Q3_2024.xlsx. Instantly, the ribbon expands. Alt+H+L opens Conditional Formatting. Alt+H+Q launches Quick Analysis — and yes, it suggests Sparklines for column E. But here’s the counterintuitive part: even though you’re using the ‘desktop’ app, it’s still syncing live with OneDrive. Change cell B2 to $1,275,000, save, and Sarah Chen (who’s editing in Teams) sees the update in under 8 seconds — no manual refresh needed. What makes this elegant is the dual identity: local power + cloud persistence. Try this: press Alt+M+M to open the Power Query Editor. Load the APAC sheet. Add a custom column: =Date.Year([Date]). Then close & load. That transformation persists — and appears in Excel for the web too (as static values). The desktop app doesn’t just give you more tools — it gives you leverage over time.
Sample transformation: You add a new column F titled ‘Forecast Accuracy %’, with formula =IF(B2=0,0,C2/B2) in F2, then format as Percentage with 1 decimal. Apply it to F2:F5. Now go back to Excel for the web — that column appears, fully formatted, with live values. But try editing the formula there? It reverts on save. That’s the handshake: desktop writes the logic, web renders the result.
Cheat Sheet
| Action | Excel for Web | Desktop App | Keyboard Shortcut |
|---|---|---|---|
| Open Power Query | Not available | Data → Get Data → Launch Power Query Editor | Alt+M+M |
| Insert Dynamic Array Formula | Works (e.g., SORT, FILTER) | Works + spill range highlighting | Ctrl+Shift+Enter (legacy) — not needed for new functions |
| Run a Macro | Disabled (grayed out) | Developer → Macros → Run | Alt+F8 |
| Paste Special Values Only | Home → Paste → Paste Values (icon) | Right-click → Paste Special → Values | Alt+E+S+V → Enter |
| Open Linked Workbook | Fails silently (links break) | Updates automatically if both files are in OneDrive | — |
