Microsoft's free Copilot Chat enhances Excel functionality amidst licensing changes

Many Microsoft 365 users access a limited Copilot Chat experience within Excel, Word, PowerPoint and OneNote, but changes in licensing are reshaping AI integration for large organisations and security considerations.

Many Microsoft 365 users still do not have a paid Copilot licence, but that does not mean Excel users are locked out of AI entirely. Microsoft has built an included Copilot Chat experience into eligible business and enterprise subscriptions, giving many organisations access to a lighter version of the assistant inside Excel, Word, PowerPoint and OneNote. The distinction matters because it changes what the tool can see, how quickly it responds and how far it can reach into workplace data. Microsoft’s support material makes clear that the add-on Copilot product and the included chat experience are not the same service.

In Excel, the included version is still useful for everyday work. Microsoft says Copilot Chat can answer questions about the workbook that is open, help explain or draft formulas and assist with summaries or analysis of uploaded files. That makes it especially valuable for users dealing with complex spreadsheets, inherited models or unclear logic. Microsoft also says the chat experience can act as a planning tool, helping users think through how an analysis should be structured before they start building it.

The limits are equally important. According to Microsoft, Copilot Chat without a paid Microsoft 365 Copilot licence does not have access to broader organisational data such as SharePoint sites, inboxes, Teams conversations or colleagues’ files. Advanced grounding in Microsoft Graph is reserved for the paid tier, which is designed to connect the assistant to a user’s wider work context. Microsoft also says the included tier does not receive priority access, so performance may be slower during busy periods.

The practical picture has also shifted quickly. Microsoft began placing Copilot Chat directly into desktop and web versions of its core productivity apps in late 2025, expanding access to users who had never purchased the add-on. But that rollout has not been uniform. Reporting from licensing specialists and workplace technology outlets says Microsoft later announced that, from April 15, 2026, organisations with more than 2,000 Microsoft 365 users would lose the in-app Copilot Chat experience in Word, Excel, PowerPoint and OneNote unless they had paid licences. Smaller organisations appear to keep the standard-access version, though Microsoft has said that access may still be throttled at peak times.

Security is another reason many IT departments are now treating the sanctioned version as preferable to consumer AI tools. Microsoft says prompts and responses entered through Copilot Chat with a work account are covered by enterprise data protection, are not used to train the underlying model and keep uploaded files in OneDrive for Business. The company also says users should see a green shield icon when enterprise data protection is active. That does not remove the need for internal controls, however. Microsoft’s own documentation says tenant administrators still determine what Copilot Chat can access and whether web grounding and other features are enabled.

The broader lesson for Excel users is that AI is most effective when it is used for exploration, explanation and drafting rather than as a replacement for reliable spreadsheet methods. Microsoft’s guidance and the Excel FAQ both stress that Copilot can make mistakes and should not be trusted blindly. For repeatable production work, formulas, Power Query and Python in Excel remain the more dependable tools. For organisations deciding whether to buy the paid licence, the immediate question is not whether AI belongs in Excel, but how much value the additional access to work data and premium features would actually add.