Yes, Excel is part of Microsoft 365 — but it’s not just "Excel with a login." The version you get depends on your license, device, and how you launch it, and mixing up the versions can break macros, freeze rows incorrectly, or silently downgrade features.
The Problem
You open Excel from the Start menu and assume it’s the full desktop app. Then your colleague sends a file with dynamic arrays — and yours shows #SPILL! errors. Or you try to use XLOOKUP on their laptop and it works fine, but your copy returns #NAME?. You check Help > About Excel and see two different build numbers side-by-side. Confusing? Absolutely. It happens because Microsoft 365 delivers three distinct Excel experiences — and they’re not interchangeable.
| Scenario | What You See | Actual Version Running | Key Limitation |
|---|---|---|---|
| Clicking Excel icon from Windows taskbar | "Excel for Microsoft 365" title bar | Desktop app (v2405, Current Channel) | Full VBA, Power Query, COM add-ins |
| Opening a file from OneDrive via browser | "Excel for the web" tab in Chrome | Web app (feature-limited) | No macros, no pivot drill-through, no GETPIVOTDATA |
| Double-clicking .xlsx in Outlook email | Blank gray window, then slow load | Excel Mobile (Windows AppX) | No ribbon customization, no Solver, no Data Model |
| Launching from Teams → Files tab | "Edit in Excel" button appears grayed out | Web app (with Teams integration) | No external data connections, no conditional formatting rules >3 |
| Using Excel shortcut pinned to taskbar | Version number says "2208" instead of "2405" | Cached legacy install (MSI) | Missing LAMBDA, LET, SEQUENCE, and new chart types |
The Solution
Fix this in under 90 seconds — no reinstall needed. First, confirm which version you're *supposed* to run. If you have Microsoft 365 Apps for enterprise or business, you want the desktop app updated monthly. Not the web version. Not the mobile one. Not an old MSI install.
- Close all Excel windows — including background processes (Ctrl+Shift+Esc → Task Manager → End Task on every "EXCEL.EXE" instance).
- Type
winverin Run (Win+R) and press Enter — verify you’re on Windows 10 v22H2 or newer. Older OS blocks latest Excel builds. - Open Settings → Apps → Installed apps → search "Microsoft 365" → click Modify → choose Quick Repair. Takes ~45 seconds.
- Launch Excel using this exact path:
C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE. Pin that to your taskbar — not the generic "Excel" tile. - In Excel, go to File → Account → Update Options → Update Now. Wait until it says "You're up to date" with build ending in "2405" or higher.
Now test it. Type =SEQUENCE(3) in A1. If you see 1, 2, 3 stacked vertically — you’ve got the real Excel in Microsoft 365. If you get #NAME?, you’re still running the old MSI or web version.
| Test | Expected Result (Correct) | Cell Reference | What It Means |
|---|---|---|---|
| =XLOOKUP("Sarah Chen",A2:A11,B2:B11,"Not found") | $45,200 | C2 | Desktop Excel in M365 supports XLOOKUP natively |
| =FILTER(A2:C11,B2:B11>40000) | Returns 3 rows (Sarah Chen, James Wu, Lena Patel) | E2# | Dynamic array behavior confirmed |
| Data → Get Data → From Web | Opens Power Query Editor | N/A | Power Query available (not in web or mobile) |
| Alt+F11 | Visual Basic Editor opens | N/A | VBA fully enabled (web/mobile block this) |
Going Further
If your company uses Microsoft 365 E3/E5, you get two extra layers most people ignore. First: Co-authoring in real time only works reliably when everyone uses the desktop app and saves to SharePoint or OneDrive (not local C:\). Second: Excel Ideas (the lightbulb icon) pulls insights from your actual data — but only if your worksheet has headers in Row 1 and at least 10 rows of consistent data. Try it on this range: B1:D10 where B1="Name", C1="Salary", D1="Start Date", and rows 2–10 contain names like "Sarah Chen", "James Wu", "Lena Patel", "Diego Morales", "Anya Kim" with salaries from $38,500 to $72,100 and dates from 2022-06-15 to 2024-03-15.
Here’s the counterintuitive bit: Turning off AutoSave breaks co-authoring. Even if you manually save every 30 seconds, others won’t see your edits until you click Save As or close the file. AutoSave must be ON (File → Options → Save → "Save AutoRecover info every X minutes" + "Keep the last autosaved version if I close without saving").
When NOT to Use This
Don’t force the desktop Excel in Microsoft 365 onto these scenarios:
- Public kiosks or shared lab PCs — desktop Excel writes registry keys and temp files. Web Excel runs sandboxed and leaves nothing behind.
- Files over 100MB with 50k+ rows — desktop Excel will hang or crash. Use Excel for the web with Power Pivot disabled, or export to CSV first.
- MacBook Air (M1/M2) with 8GB RAM — the desktop app consumes 1.2GB RAM just loading. Stick with web Excel or iPad Excel for lightweight work.
- Legacy macros written for Excel 2003 — they’ll run, but may fail on modern security defaults. Test them in a sandbox first.
Also: Never update Excel in Microsoft 365 during a live Teams meeting where someone is screen-sharing an Excel file. The auto-update triggers a restart — and kills the share.
Keyboard Shortcuts
| Action | Shortcut | Notes |
|---|---|---|
| Open Visual Basic Editor | Alt+F11 |
Only works in desktop Excel |
| Force update current workbook | Ctrl+Alt+F5 |
Refreshes all queries, pivots, and formulas |
| Open Account settings | Alt+F-T-A |
Alt+F → File tab, T → Account, A → Account options |
| Toggle AutoSave on/off | Alt+Q, type "autosave", Enter |
Search bar shortcut — faster than navigating menus |
