How to enable Copilot on Microsoft Excel

So, you paid for Copilot Pro, but is it not available on Microsoft Excel? Here's the fix.

Microsoft Excel enable Copilot
Microsoft Excel enable Copilot / Image: Mauro Huculak
  • To enable the new Copilot on Microsoft Excel, you need a Microsoft 365 and Copilot Pro subscription associated with the Microsoft account.
  • On Excel, if the “Copilot” feature is still missing, open Excel > File > Account and click the “Update License” button.
  • If you don’t have a pro subscription, you won’t be able to access the chatbot AI on any of the apps.

On Microsoft Excel, Copilot Pro should enable automatically, but if it’s still missing, in this guide, I will show you how. Copilot Pro is the $20 subscription of the AI that’s based on Copilot (free) but has a bunch of new features, such as priority access to GPT-4 and GPT-4 Turbo, enhanced AI image creation, the ability to create customs GPTs (coming soon), and access to chatbot from Microsoft 365 apps. 

The Copilot features will depend on the application. In the case of Excel, you can ask the chatbot to make more sense of the information by allowing you to analyze and explore the data in the spreadsheet. In addition, you can ask virtually anything using natural language. The chatbot is also smart enough to suggest formulas based on your queries, predict “what if” scenarios, and find data correlations. In addition, you will be able to instantly create a SWOT analysis or a PivotTable based on data.

If you’re currently subscribed to Microsoft 365 Personal or Family, it’s crucial to know that Copilot isn’t included in these plans. Instead, it’s an independent product, requiring a separate “Copilot Pro” subscription priced at $20 per month per user. To ensure access to the AI assistant in Excel, confirm that your Microsoft 365 and Copilot Pro subscriptions are linked to the Microsoft account used for signing into apps on Windows 11, 10, or macOS.

In my case, I have both subscriptions, but Microsoft Excel was still missing the “Copilot” feature. If this is also your case, you have to make sure to update the license of the applications. If the option isn’t available, then you may need to reinstall the Microsoft 365 apps to make it all work.

In this guide, I will outline the two methods you can use to enable Copilot Pro on Microsoft Excel on Windows 11. (You may also need to follow the steps to update the license on OneNote and Word.)

Enable Copilot Pro in Excel (with license option)

To enable Copilot Pro in Excel, use these steps:

  1. Open Excel on Windows 11.

  2. Click on File and choose the Account option.

  3. Click the Update License button.

    Excel update license option to enable Copilot

    Quick tip: You may need to click the button twice to get it to work.
  4. Click the Sign in button.

    Microsoft 365 confirm Excel license

  5. Confirm the Microsoft account associated with the Microsoft 365 and Copilot Pro subscription.

  6. Click the Close button.

  7. Close all the instances of the Microsoft 365 apps.

  8. Reopen Excel to access Copilot Pro.

Once you complete the steps, the product license will update, and Copilot Pro should now appear on Microsoft Excel. The AI assistant should now be available from the “Home” tab, next to the Microsoft Editor button.

Enable Copilot Pro in Excel (missing license option)

If the “Update License” option is missing, you’re likely not using the correct version of the suite of apps that allows you to access Copilot in Excel. In this case, you will need to completely uninstall the Microsoft 365 (Office) apps and install a fresh copy by downloading the installer from your Microsoft account.

1. Uninstall Microsoft 365

To completely uninstall the Microsoft 365 apps on Windows 11, use these steps:

  1. Download Microsoft Support and Recovery Assistant tool.

  2. Double-click the executable to launch the setup.

  3. Click the Install button.

    Office recovery assistant tool

  4. Click the Agree button to confirm the terms.

  5. Select the version of the product – for example, Office 2021, 2019, or 365.

    Uninstall Office 2021 or 365

  6. Click the Next button.

  7. Confirm the Office uninstall by checking the option that you have saved your work.

  8. Click the Next button.

  9. Click the Restart button.

After you complete the steps, the apps will be uninstalled from the computer, and you can proceed with the installation of the latest version of the Microsoft 365 apps.

2. Reinstall Microsoft 365 apps

To download and install the Microsoft 365 apps on Windows 11, use these steps:

  1. Open Microsoft account.

  2. Sign in with your Microsoft 365 account.

  3. Click on the Account tab.

  4. Click the Manage option for the “Microsoft 365” subscription.

    Microsoft account manage 365 subscription

  5. Click the Install button in the “Microsoft 365 apps for your devices” setting.

    Microsoft 365 install option

  6. Choose the installation language.

  7. Select the “Microsoft 365 64-bit” option.

    Microsoft 365 installer download

    Quick note: You should be able to choose any option, but this is the option that worked for me.
  8. Click the Install button to download the installer on your computer.

  9. Double-click the OfficeSetup.exe to install the apps.

  10. Click the Finish button.

Once you complete the steps, the supported version of the apps will install on the computer. You can now check if Copilot Pro is now available, but if it’s not, you should now be able to update the license with the steps below.

3. Enable Copilot in Excel

To enable Copilot Pro in Excel, use these steps:

  1. Open Excel.

  2. Click on File and choose the Account option.

  3. Click the Update License button.

    Excel update license option to enable Copilot

    Quick tip: You may need to click the button twice to get it to work.
  4. Click the Sign in button.

    Microsoft 365 confirm Excel license

  5. Confirm the Microsoft account associated with the Microsoft 365 and Copilot Pro subscription.

  6. Click the Close button.

  7. Close all the instances of the Microsoft 365 apps.

  8. Reopen Excel to access Copilot Pro.

After you complete the steps, Copilot Pro will be available in Excel and from any of the other apps from the “Home” tab.

Here’s the process of getting Copilot Pro, an overview of the product, and how to cancel the service:

Update January 19, 2024: This guide has been updated to ensure accuracy and reflect changes to the process to enable the AI feature on Excel.

About the author

Mauro Huculak is a Windows How-To Expert who started Pureinfotech in 2010 as an independent online publication. He has also been a Windows Central contributor for nearly a decade. Mauro has over 15 years of experience writing comprehensive guides and creating professional videos about Windows and software, including Android and Linux. Before becoming a technology writer, he was an IT administrator for seven years. In total, Mauro has over 21 years of combined experience in technology. Throughout his career, he achieved different professional certifications from Microsoft (MSCA), Cisco (CCNP), VMware (VCP), and CompTIA (A+ and Network+), and he has been recognized as a Microsoft MVP for many years. You can follow him on X (Twitter), YouTube, LinkedIn and About.me. Email him at [email protected].