Does Microsoft Office 365 have Excel? Why does your laptop show Excel in the Start menu but open a browser tab instead? Why did your finance colleague get Excel 2021 while yours says 'Excel for the web' with grayed-out features?
The Problem
You clicked 'Install Office' from your company portal. You opened Excel. You typed =SUM(A1:A5). It worked. Then you tried =XLOOKUP() — and got #NAME?. You checked your subscription on account.microsoft.com… and saw 'Microsoft 365 Business Standard'. But no one told you that 'Standard' ≠ 'Full Excel'.
This confusion isn’t rare. It’s baked into how Microsoft bundles, markets, and licenses Excel across over a dozen plan names — some delivering desktop Excel, others only web or mobile versions, and a few locking advanced functions behind extra add-ons.
| Plan Name | Desktop Excel (Win/mac) | Excel for the Web | Offline Use | XLOOKUP / LAMBDA / Dynamic Arrays |
|---|---|---|---|---|
| Microsoft 365 Personal | ✓ | ✓ | ✓ | ✓ |
| Microsoft 365 Business Basic | ✗ | ✓ | ✗ (no offline save) | Partial (no LAMBDA) |
| Microsoft 365 Apps for enterprise | ✓ | ✓ | ✓ | ✓ |
| Office 365 E3 (legacy) | ✓ | ✓ | ✓ | ✓ (if updated) |
| Office 365 Business Essentials | ✗ | ✓ | ✗ | ✗ |
| Microsoft 365 F3 (Frontline) | ✗ | ✓ | ✗ | ✗ |
Note: 'Office 365' is now branded as 'Microsoft 365', but legacy plans still appear in admin centers. And yes — 'Business Basic' gives you Outlook, Teams, and SharePoint… but *not* the Excel desktop app. That’s why Sarah Chen (Acme Corp, Finance Analyst) couldn’t run her quarterly forecast model on her new laptop — she’d been assigned Basic, not Standard.
The Solution
Here’s how to confirm *exactly* what version of Excel you have — and fix it in under 3 minutes.
- Open any Excel file (or launch Excel). Click File → Account.
- Look at the Product Information section. If it says 'Microsoft 365 Apps' or 'Office 365 ProPlus', you have the full desktop app. If it says 'Microsoft 365 Business Basic' or shows only web apps, you don’t.
- If you’re missing desktop Excel but should have it: go to office.com, sign in, click Install Office (top right), then choose Office 365 Apps — *not* 'Office Online'.
- Run the installer. When done, open Excel, go to File → Account → About Excel. You’ll see version numbers like Version 2405 (Build 17628.20148). That’s full Excel.
Now test it: In cell A1, type 1. In A2, type 2. In B1, type =SEQUENCE(2). If it spills two rows down — you’ve got dynamic arrays. If you get #NAME?, your install didn’t complete or your license hasn’t synced.
| Before Fix | After Fix | Proof It Worked |
|---|---|---|
| Excel opens in Edge as 'Excel for the web' | Excel launches as a native Windows app (icon has blue 'X') | =FILTER(A1:A10,A1:A10>5) returns a spilled array in B1:B5 |
| No 'Developer' tab visible | 'Developer' tab appears after enabling via File → Options → Customize Ribbon | You can record macros, edit VBA, and use Power Query Editor (Data → Get Data → Launch Editor) |
| 'Account' page shows 'Business Basic' | 'Account' page now reads 'Microsoft 365 Apps for enterprise' | Version number matches current monthly channel (e.g., Build 17628.x) |
Going Further
You’re not done yet — especially if you manage devices or support others.
First: License sync delay. Even after assigning 'Microsoft 365 Apps for enterprise' in the admin center, desktop Excel may stay grayed out for up to 2 hours. Don’t reinstall — just wait and run OfficeC2RClient.exe /update user from Command Prompt (Admin).
Second: Volume licensing vs. subscription. Some companies still use perpetual Office 2019/2021 licenses. Those do *not* require Microsoft 365 — but they also don’t auto-update XLOOKUP or LET. So even if you have 'Excel 2021', you might lack features introduced in 2022+ updates.
Third: Mac users get fewer features. As of June 2024, Excel for Mac supports XLOOKUP and FILTER — but not LAMBDA or LET. So if your team uses =LAMBDA(x,x^2) in A1, it’ll break when shared with Mac colleagues. Test on both platforms.
Fourth: Shared devices need special setup. In kiosks or lab computers, Excel may default to web mode unless you configure Group Policy: Computer Configuration → Administrative Templates → Microsoft Office → Security Settings → Disable Excel for the web.
When NOT to Use This
Don’t force-install desktop Excel if:
- You’re on a Chromebook (only Excel for the web or Android app works natively)
- Your organization blocks .exe installs — ask IT for the Click-to-Run XML config instead
- You’re using a government GCC High tenant — desktop Excel requires separate approval and may be restricted
- Your device has ≤2 GB RAM — Excel desktop will crash repeatedly; stick with web or mobile
Also: Installing Excel doesn’t magically enable Power Pivot in Business Basic plans. That feature requires 'E5' or 'Business Premium'. Trying to open a .xlsx with embedded data models will show 'This workbook contains features not available in your version.'
And here’s the counterintuitive tip: If Excel won’t install, try signing in with a *different* Microsoft account first. We saw this at a logistics firm in Shenzhen — their SSO forced Azure AD auth, but the Office installer needed a personal @outlook.com login to bypass conditional access. Once installed, it switched back to corporate auth seamlessly.
Keyboard Shortcuts
| Action | Windows Shortcut | Mac Shortcut |
|---|---|---|
| Open Account settings | Alt + F → A | Cmd + , |
| Check Excel version | Alt + F → A → About Excel | Cmd + Option + R |
| Toggle ribbon visibility | Ctrl + F1 | Cmd + Option + R |
| Force update Office | Alt + F → A → Update Options → Update Now | Cmd + Shift + U |
