Microsoft to Retire Experimental =COPILOT Function in Excel

Microsoft is retiring the experimental =COPILOT worksheet function in Excel on September 14, 2026. The move marks a strategic shift in how the company integrates generative AI into its flagship spreadsheet software.

According to Microsoft 365 Admin message MC1454373, the =COPILOT function—which allowed users to prompt AI directly within a cell formula—will no longer be available for creating new formulas after the retirement date. The feature was never a general-release tool; it was an experimental preview available specifically to participants in the Excel Insider and Frontier programs. Microsoft is now directing all users to the dedicated Copilot side pane as the primary alternative for AI-assisted tasks.

The Shift to Sidecar AI

For the past several months, Microsoft has been aggressively integrating large language models (LLMs) across the Microsoft 365 suite. The =COPILOT function represented a bold attempt to treat AI prompting like a traditional spreadsheet operation, similar to how a user would employ =SUM() or =VLOOKUP(). By placing the AI directly in the formula bar, Microsoft tested whether users preferred a seamless, grid-integrated experience for data manipulation.

However, the company is now pivoting toward a more centralized "pane" experience. This approach separates the AI's conversational interface from the core spreadsheet grid, preventing the formula bar from becoming overly complex and ensuring that AI interactions do not disrupt the layout of the data itself.

Impact on Power Users

This transition signals a clear preference for a "sidecar" AI assistant over "in-cell" functionality. While the side pane offers a robust interface for chatting with data, the loss of the =COPILOT function represents a significant disruption for power users. Those who built specialized workflows around formula-based AI prompts—specifically for automating data classification or generating content across hundreds of cells simultaneously—will find their automation methods obsolete.

Unlike the side pane, which typically handles broader tasks or specific selections, the in-cell function allowed for a more programmatic application of AI across a range of cells. The removal of this capability forces a change in how advanced users approach AI-driven data synthesis within their workbooks.

What to Watch

As the September 2026 deadline approaches, the industry will be watching to see if Microsoft introduces any other programmatic ways to trigger AI within cells, such as through Office Scripts or Power Automate. For now, the official directive remains clear: the side pane is the future of the Excel AI experience. Users currently relying on the Frontier preview should begin migrating their workflows to the side pane to avoid service interruption.