Troubleshooting “Activation Wizard” Errors That Disable Formula Editing

When you open Excel and see the Microsoft Office Activation Wizard pop up—accompanied by a yellow or red banner reading “PRODUCT DEACTIVATED,” “Unlicensed Product,” or “Subscription Expired”—Excel places itself into Reduced Functionality Mode.

In this state, you can open and view spreadsheets, but most interface elements are grayed out. You cannot enter new numbers, insert rows, edit existing formulas, or save changes to your workbook.

Quick Answer

To restore editing immediately, sign out and sign back in to refresh your license token:

1. In Excel, go to File > Account.
2. Under User Information, click Sign out.
3. Close all open Office applications.
4. Reopen Excel, click Sign In, and enter the email address tied to your active Microsoft 365 subscription or retail license.

If the prompt persists, check your workstation clock: an incorrect system date or time will block the secure SSL handshake between your computer and Microsoft’s licensing servers.

---

Why Reduced Functionality Mode Disables Formula Editing

Microsoft Office licenses require periodic verification. Retail versions (Office 2019, 2021, 2024) validate an embedded product key against activation servers, while Microsoft 365 subscriptions require your machine to ping Microsoft servers at least once every 30 days.

When this verification handshake fails, Excel protects the software by disabling the authoring engine:

License Check Fails / Activation Wizard Triggers
 │
 ├── Reduced Functionality Mode Activated
 │    ├── Ribbon tools gray out (Formulas, Home, Insert)
 │    ├── Formula bar is locked to read-only
 │    └── Save and Save As operations are blocked
 │
 └── Core Causes:
      ├── Stale or conflicting cached credentials
      ├── Multiple competing Office licenses on one machine
      ├── System clock drift breaking TLS certificates
      └── Corporate proxy or firewall blocking licensing endpoints

---

Step-by-Step Recovery Workflow

Follow these troubleshooting steps in sequence to clear stalled activation states and restore formula editing.

Step 1: Verify Account Identity and License Allocation

Before changing system settings, confirm that the account currently signed in actually owns a valid license.

1. Open your browser and navigate to account.microsoft.com/services (or portal.office.com if using a corporate work/school account).
2. Sign in and verify that your subscription status is listed as Active.
3. Check the license type. If your account shows that a subscription expired or your enterprise admin revoked your seat, formula editing will remain locked until billing or seat assignments are updated.

Step 2: Clear Corrupted Office Credentials in Windows

Windows Credential Manager stores authentication tokens locally. If you recently changed your Microsoft password or your organization migrated accounts, stale cached tokens will cause the Activation Wizard to fail repeatedly.

1. Close all Office programs (Excel, Word, Outlook, Teams).
2. Open the Windows Start menu, type Credential Manager, and select it.
3. Click on Windows Credentials.
4. Scroll down to the Generic Credentials section.
5. Look for any entries containing MicrosoftOffice16_Data:, MS.Office:Default, or ADAL.
6. Click each entry, select Remove, and confirm.
7. Restart your computer, launch Excel, and sign in again when prompted.

Step 3: Check System Date, Time, and Time Zone

Licensing servers use encrypted HTTPS handshakes. If your computer’s local clock differs from the server’s Coordinated Universal Time (UTC) by more than a few minutes, the security certificates will be rejected as expired or not yet valid.

1. Right-click the clock in the bottom-right corner of your taskbar and select Adjust date and time.
2. Toggle Set time automatically to Off, then turn it back to On.
3. Ensure Set time zone automatically is On, or manually select your correct time zone.
4. Click the Sync now button under “Additional settings.”
5. Reopen Excel and click Retry on the Activation Wizard.

Step 4: Remove Orphaned Product Keys via Command Line

If you previously had an older version of Office (like Office 2016 or a trial edition) installed before upgrading to Microsoft 365, the old product key may still be registered in the background. Excel will try to validate against the old, expired key instead of your active subscription.

1. Open the Start menu, type cmd, right-click Command Prompt, and choose Run as Administrator.
2. Navigate to your Office installation directory by running one of the following commands:
   • For 64-bit Office on 64-bit Windows: cd "C:\Program Files\Microsoft Office\Office16"
   • For 32-bit Office on 64-bit Windows: cd "C:\Program Files (x86)\Microsoft Office\Office16"

• For 64-bit Office on 64-bit Windows: cd "C:\Program Files\Microsoft Office\Office16"

cd "C:\Program Files\Microsoft Office\Office16"

• For 32-bit Office on 64-bit Windows: cd "C:\Program Files (x86)\Microsoft Office\Office16"

cd "C:\Program Files (x86)\Microsoft Office\Office16"

1. Check for installed product keys by running the Office Software Protection script: cscript ospp.vbs /dstatus

cscript ospp.vbs /dstatus

1. Look through the output for lines marked LICENSE STATUS and Last 5 characters of installed product key:.
2. If you see multiple keys listed—especially any marked EXPIRED or belonging to an older version—note the 5-character key and remove it:(Example: cscript ospp.vbs /unpkey:XWB29) cscript ospp.vbs /unpkey:<LAST5CHARACTERS>

cscript ospp.vbs /unpkey:<LAST5CHARACTERS>

1. Repeat this removal for any obsolete keys, leaving only your active license (or remove all of them to force a clean slate).
2. Relaunch Excel; it will prompt you to sign in. Enter your credentials to bind the fresh license.

If your workbook remains locked or individual cells still refuse input after your license is verified, the sheet itself may have structural password protection applied. See #REF! in Protected Sheets: Missing Permissions for formula updates to differentiate between licensing locks and worksheet security rules.