Microsoft retires Excel's COPILOT() function in favor of side pane interface

Microsoft introduced the COPILOT() function in August 2025 as a way to invoke AI assistance directly from a worksheet cell. The function was initially available to Beta Channel users with a Microsoft 365 Copilot license and later extended to Excel for the web through the Frontier program. Its removal reflects a strategic shift toward consolidating AI interactions within the Copilot side pane, which Microsoft now considers sufficient for all use cases.

The decision to retire the function was communicated via an update to the Microsoft 365 roadmap, where the company stated it would not move forward with the feature. The change takes effect on September 14, 2026, giving users a narrow window to replace any COPILOT() formulas in their spreadsheets. Since the function remained in preview, Microsoft’s messaging suggests users should not have relied on it for production workflows, though this may not align with real-world adoption.

Microsoft’s justification for the removal centers on streamlining the Copilot experience within Excel. The side pane is positioned as offering the same AI-powered capabilities, including text summarization, data classification, content generation, and web-based information retrieval. However, the loss of in-cell invocation may disrupt workflows for users who preferred embedding AI directly into formulas rather than toggling between cells and a side panel.

The retirement of COPILOT() also highlights broader challenges in integrating AI into productivity tools. Microsoft has faced user feedback about interface consistency, such as the ability to relocate the floating Copilot button. By removing the function, the company is doubling down on a single, supported interface, which may reduce fragmentation but could limit flexibility for power users. Google Sheets, by contrast, continues to offer a similar AI function, suggesting differing approaches to in-cell AI integration.

For engineers and spreadsheet users, the change underscores the risks of adopting preview features in production environments. While Microsoft’s documentation warned against relying on COPILOT() for critical decisions, the function’s removal will still require manual updates to affected spreadsheets. The shift to the side pane may simplify the user experience, but it also removes a direct, formula-based method of interacting with AI, which could impact automation and scripting workflows.