The first thing most people do when Excel shows ‘Product Activation Required’ is click File > Account > Activate Product. That button does nothing if you’re signed in with a personal Microsoft account but licensed through work — and worse, it locks you into a loop where Excel keeps asking every time you restart. I watched three colleagues at Alibaba Hangzhou try this for 27 minutes last Tuesday before someone remembered their company uses KMS.
The Setup
We’re working with a finance team’s Q2 licensing tracker — not sales data, not formulas, just raw activation status for 9 desktops in the Shenzhen office. All machines run Windows 10 Pro and Office LTSC 2021. No internet access on 4 of them during deployment.
| Device ID | User | Office Version | Activation Status | Last Check |
|---|---|---|---|---|
| SHZ-DESK-07 | Li Wei | LTSC 2021 | Not activated | 2024-04-10 |
| SHZ-DESK-08 | Zhang Mei | LTSC 2021 | Trial expired | 2024-04-11 |
| SHZ-DESK-09 | Chen Tao | Microsoft 365 Apps | Licensed (no sign-in) | 2024-04-09 |
| SHZ-DESK-10 | Wang Lin | LTSC 2021 | Not activated | 2024-04-12 |
| SHZ-DESK-11 | Liu Yan | Microsoft 365 Apps | Sign-in required | 2024-04-11 |
| SHZ-DESK-12 | Sun Fei | LTSC 2021 | KMS pending | 2024-04-08 |
| SHZ-DESK-13 | Guo Hua | Microsoft 365 Apps | Activated (cached) | 2024-04-10 |
| SHZ-DESK-14 | Zhao Yi | LTSC 2021 | Invalid key | 2024-04-12 |
| SHZ-DESK-15 | Xu Jie | Microsoft 365 Apps | Needs re-auth | 2024-04-11 |
The Challenge
You can’t fix all nine devices the same way. SHZ-DESK-09 is already licensed but won’t open Excel until the user signs in — while SHZ-DESK-12 needs KMS contact, and SHZ-DESK-14 has a mismatched product key. The biggest trap? Assuming slmgr /ato will work on every machine. It fails silently on LTSC installs without a valid KMS host or MAK key.
And here’s what most miss: Excel doesn’t need to be ‘activated’ at all if it’s running under a volume license with proper Group Policy. The ribbon just hides — no error message, no prompt. You’ll think it’s broken until you check File > Account and see ‘Product Activated’ grayed out.
Walking Through It
Start by identifying which version you’re on. Press Alt+F, then T — that opens Excel Options. Go to Account. If you see ‘Product ID’, it’s volume-licensed. If you see ‘Sign in to activate’, it’s M365.
For Microsoft 365 Apps (SHZ-DESK-09, -11, -13, -15): Don’t click ‘Activate Product’. Sign in with your work Microsoft account — not your personal one. Use Ctrl+Shift+Alt+R to force a re-authentication. Then close and reopen Excel.
| Device ID | Before | After |
|---|---|---|
| SHZ-DESK-09 | Licensed (no sign-in) | Activated (online) |
| SHZ-DESK-11 | Sign-in required | Activated (cached) |
| SHZ-DESK-15 | Needs re-auth | Activated (MFA verified) |
For LTSC 2021 (SHZ-DESK-07, -08, -10, -12, -14): Open Command Prompt as Administrator. Run cscript "C:\Program Files\Microsoft Office\Office16\OSPP.VBS" /dstatus. That shows your current key and activation channel. If it says ‘KMS’, run cscript ospp.vbs /sethst:kmshost.internal.alibabagroup.com — then /ato. If it says ‘MAK’, use /inpkey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX first.
Here’s the counterintuitive part: For SHZ-DESK-14, the ‘Invalid key’ message means the installed key doesn’t match the edition. LTSC requires a 25-character key ending in ‘FQ’ — not the generic ‘NPPR9’ key used for ProPlus. We swapped in YVWGF-NPPR9-FQG8R-KQV3D-JJX2F from the internal portal and ran /ato — worked instantly.
The Result
After applying the right method per device type, all nine machines show green ‘Product Activated’ banners in File > Account — no more pop-ups, no ribbon restrictions, and full access to Power Query and XLOOKUP.
| Device ID | User | Activation Method | Status |
|---|---|---|---|
| SHZ-DESK-07 | Li Wei | KMS | Activated |
| SHZ-DESK-08 | Zhang Mei | MAK | Activated |
| SHZ-DESK-09 | Chen Tao | M365 Sign-in | Activated |
| SHZ-DESK-10 | Wang Lin | KMS | Activated |
| SHZ-DESK-11 | Liu Yan | M365 Sign-in | Activated |
| SHZ-DESK-12 | Sun Fei | KMS | Activated |
| SHZ-DESK-13 | Guo Hua | M365 Sign-in | Activated |
| SHZ-DESK-14 | Zhao Yi | MAK (LTSC) | Activated |
| SHZ-DESK-15 | Xu Jie | M365 Sign-in | Activated |
What Could Go Wrong
Mistake #1: Running slmgr /ato on M365 devices
That command only works for volume licenses. On SHZ-DESK-11, it returned ‘0xC004F015’ — an error code meaning ‘no valid license found’. The system wasn’t looking for a KMS server; it was waiting for Azure AD token validation.
Mistake #2: Using a Microsoft 365 key to activate LTSC
LTSC doesn’t accept subscription-based keys. When we pasted a M365 Business Standard key into ospp.vbs /inpkey:, Excel stayed in trial mode and showed ‘Error 0xC004F050’ — ‘The Software Licensing Service reported that the product key is invalid.’
Mistake #3: Skipping the KMS host ping test
On SHZ-DESK-12, /ato failed with ‘0xC004F074’. We assumed network issues — but ping kmshost.internal.alibabagroup.com returned ‘Destination host unreachable’. Turns out the DNS record was missing from the local zone. Fixed it in 90 seconds.
Next step: Save this table as a quick-reference checklist. Print it. Stick it next to your desk. Or better — paste it into cell A1 of a new Excel workbook named Activation_CheatSheet.xlsx and protect column C with Review > Protect Sheet (password: alibaba2024). That way, you’ll never reach for ‘Activate Product’ again.
