How to Restore Copilot for a Microsoft 365 Family Member in Excel

If a family member sharing your Microsoft 365 plan suddenly loses access to Copilot in Excel, the disruption usually stems from account credential mismatches, unsupported file states, or licensing gaps. Because Copilot operates as a supplementary service layer on top of standard consumer plans, restoring the AI assistant requires checking both the individual’s subscription status and the specific workbook formatting. The workflow below will guide you through verifying entitlements, refreshing local software tokens, and configuring the spreadsheet environment to bring the feature back online.

Verifying the Individual Copilot Pro License

Microsoft 365 Family provides Office desktop applications and cloud storage to up to six people, but it does not natively include Copilot access. For the AI assistant to function in Excel, the specific family member must hold an active Copilot Pro subscription tied directly to their personal Microsoft account. A single Copilot Pro license cannot be shared across a Microsoft 365 Family group.

To confirm the account holds the necessary license:

• Open a web browser and navigate to the Microsoft Account Services and Subscriptions portal.
• Log in using the specific email address of the family member who is missing the feature.
• Scroll down to the Subscriptions section and locate Copilot Pro.
• If the subscription is missing or expired, the user must purchase or renew Copilot Pro individually. If the subscription is active, the issue lies within the local desktop application.

Refreshing Excel Credentials and Updating the License

Excel frequently caches older subscription data upon launch. If a family member recently acquired a Copilot Pro license, or if Microsoft's authentication token has expired, the desktop application will fail to load the AI tools. Forcing a license update clears the outdated cached token.

To refresh the application credentials:

• Launch the desktop version of Excel and click on File in the top-left corner.
• Select Account from the bottom-left navigation menu.
• Under the User Information section, verify that the signed-in email address exactly matches the account holding the active Copilot Pro license. If a different profile is active, click Sign out, restart the application, and sign back in with the correct Microsoft account.
• Click the Update License button located under the Product Information header.
• Sign in again when prompted to authenticate the refresh request.
• Close Excel completely and relaunch the program to verify the Copilot icon has returned to the Home ribbon.

Fixing Unsupported File Formats and Storage Locations

Even with a valid, fully refreshed license, the AI assistant will remain hidden or grayed out if the active workbook does not meet Microsoft's strict cloud synchronization and data formatting requirements. Copilot cannot process local files or raw cell ranges.

To configure your document for AI processing:

• Enable Cloud Syncing: Look at the Quick Access Toolbar in the top-left corner of the Excel window and switch the AutoSave toggle to the "On" position. When prompted, select the personal OneDrive account associated with the active license. Copilot requires real-time cloud connectivity to analyze data.
• Format Data as a Table: Highlight the specific range of data you want to analyze. Navigate to the Insert tab on the ribbon and click Table (or press Ctrl+T on your keyboard). Check the box that says "My table has headers" and click OK.

Once the document is syncing to OneDrive and the data is structured within an official Table format, the AI button on the Home tab will become clickable and ready for use.

Utilizing WPS Office for Accessible AI Spreadsheet Tools

Managing individual $20/month Copilot Pro subscriptions for multiple family members on top of a base Microsoft 365 plan can become excessively expensive. If mandatory OneDrive syncing and strict table formatting restrictions hinder your data management, WPS Office provides a streamlined alternative.

WPS Office integrates robust AI capabilities directly into its suite, allowing you to generate complex formulas, analyze datasets, and draft reports without requiring separate, per-user license assignments or mandatory cloud-saving constraints. You can open your existing .xlsx files directly in WPS Spreadsheet and work locally. To utilize these features, open your workbook, click the WPS AI tab on the main ribbon, and select AI Formula. You can then describe the calculation you need in natural language, and the software will generate the exact formula for your selected cells. This eliminates the need to upload sensitive family financial documents to the cloud, offering immediate AI functionality for files stored directly on your local hard drive.

Use Word, Excel, and PPT for FREE

Free Download

Frequently Asked Questions

Does a Microsoft 365 Family subscription cover Copilot access?

No. The family tier only covers the base desktop applications and OneDrive storage limits. Copilot Pro operates as a separate, premium subscription layer. It must be purchased individually for each Microsoft account within the family group that wishes to utilize AI generation features in Word, Excel, or PowerPoint.

Why is the Copilot button grayed out even though I have a Pro subscription?

In Excel, this symptom almost always indicates that your data is not formatted as a recognized table, or the file is saved locally to your computer's storage. You must save the file to OneDrive by enabling AutoSave, and convert your raw data range into a defined Table using the Insert > Table command before the tool can interact with it.

Can I transfer my Copilot Pro license to another family member?

Microsoft does not provide a mechanism to transfer active subscriptions directly between accounts. To move access to a different individual, you must cancel the subscription on the current account, turn off recurring billing, and purchase a new subscription using the target family member's Microsoft account.

How do I force Excel to recognize a newly purchased Copilot license?

Navigate to File > Account within the desktop application and click the Update License button. This action forces the software to ping the authentication servers and download the latest subscription entitlements. You must restart the application afterward to load the updated ribbon interface containing the new tools.