Microsoft is officially ending the life of the =COPILOT function in Excel, a move that comes less than a year after the feature first appeared in preview. The company has confirmed that the function will no longer be available starting September 14, 2026. This deprecation occurs well before the feature could have ever reached general availability, effectively making it a short-lived experiment for Microsoft 365 users.
The announcement, detailed in Microsoft’s official explanation, clarifies that the =COPILOT function was offered exclusively through the Insider and Frontier programs. While the feature allowed users to embed natural language prompts directly into spreadsheet cells, Microsoft now states it will discontinue support to “streamline the Copilot experience within Excel.”
What was the =COPILOT function?
For those who tested the feature since its preview launch in August 2025, the =COPILOT function represented a shift toward formula-driven AI. Instead of relying on a separate chat interface, users could type a prompt directly into a cell. For example, entering =COPILOT("Summarize this text") would return the AI’s output right in the spreadsheet.
The function supported a variety of tasks, including summarizing text, categorizing feedback, and retrieving information from the web. It was designed to blend AI capabilities directly into the workflow of Excel power users who preferred manipulating data via formulas rather than clicking through menus.
However, the feature came with significant restrictions. Microsoft explicitly warned users against using =COPILOT for numerical calculations, tasks requiring context from other parts of a workbook, or anything with legal, regulatory, or compliance implications. These limits made the function unsuitable for many professional use cases, particularly in finance and legal sectors where accuracy and auditability are critical.
Why is Microsoft removing it?
Microsoft’s reasoning centers on unification and control. The company states that customers can continue using Copilot in Excel through the Copilot side pane, which provides “many of the same AI-powered capabilities.” This includes summarizing text, classifying data, generating content, and retrieving web information.
By moving functionality into the side pane, Microsoft is consolidating its AI tools into a single, supported interface. This approach allows the company to manage permissions, data privacy, and feature rollouts more consistently. It also aligns with a broader strategy to treat Copilot as a unified assistant rather than a scattered collection of features tagged with the Copilot brand.
The decision to remove the function entirely, rather than just ending preview status, suggests Microsoft has determined that the formula-based approach does not fit its long-term vision for Excel. The company is prioritizing a guided, pane-based experience where users interact with AI through a dedicated workspace rather than embedding prompts into their data structures.
What this means for you
For users currently relying on the =COPILOT function, the implications are immediate. Microsoft has stated that users will not be able to create new formulas using the =COPILOT function after September 14, 2026. This means any new work you start will need to use the side pane or other supported AI features.
Existing spreadsheets containing =COPILOT formulas may also be affected. While Microsoft did not explicitly detail the behavior of legacy formulas, the discontinuation of the function typically implies that cells containing it will return errors or display the last cached result until manually updated. If you have critical workbooks built around this function, you should plan to migrate those formulas to the side pane or alternative methods before the deadline.
The shift also highlights the risks of using preview features in production environments. Since =COPILOT was never generally available, it lacked the stability guarantees and long-term support commitments of standard Excel features. Users who adopted it early may find themselves needing to refactor their workflows significantly.
The broader Copilot strategy
This removal is part of a larger trend of Microsoft reining in its Copilot ecosystem. Over the past year, the company has faced criticism for diluting the Copilot brand by attaching it to dozens of different apps and features, many of which offered limited value. The free version of Copilot, in particular, has been described by some reviewers as a “tech demo” designed to push users toward paid tiers.
By removing the =COPILOT function, Microsoft is signaling a move toward a more targeted and controlled Copilot experience. The company appears to be focusing on features that integrate deeply with Microsoft 365 workflows while avoiding the pitfalls of over-exposure. The side pane approach offers a more consistent user experience and allows Microsoft to better manage data security and compliance across its AI offerings.
For now, the =COPILOT function remains available to Insider and Frontier users, but its expiration date is set. Those interested in Excel’s AI capabilities should likely focus on the side pane features, which represent the future of Copilot in Excel.
Source: Latest from Windows Central
Over to you: Are you currently using the =COPILOT function in your spreadsheets, or did you stick to the side pane from the start?
