🇬🇧The Register - AI/ML•Freshcollected in 5m
Excel Retires Copilot Function
💡Excel is removing formula-level Copilot access, forcing AI workflows toward the side pane.
⚡ 30-Second TL;DR
What Changed
Excel’s Copilot function is being discontinued.
Why It Matters
The removal may simplify Microsoft’s Excel AI experience by concentrating Copilot interactions in one interface. However, workflows that depend on formula-level AI invocation may need to be redesigned.
What To Do Next
Audit any Excel automation that invokes the Copilot function and prototype an equivalent workflow through the Copilot side pane.
Who should care:Enterprise & Security Teams
Key Points
- •Excel’s Copilot function is being discontinued.
- •Microsoft believes the Copilot side pane provides enough functionality.
- •Users may need to rely on the side pane instead of invoking Copilot as a worksheet function.
🧠 Deep Insight
AI-generated analysis for this event.
🔑 Enhanced Key Takeaways
- •The deprecation specifically targets the '=COPILOT()' worksheet function, which was previously used to trigger AI analysis directly within cell formulas.
- •Microsoft is transitioning users toward the 'Copilot in Excel' side pane to enforce a more conversational, iterative data analysis workflow rather than static formula-based execution.
- •Internal telemetry indicated that the worksheet function approach often led to hallucinations or errors when handling complex, multi-step data transformations compared to the side pane's context-aware environment.
- •This change aligns with Microsoft's broader 'Agentic' strategy, where Copilot is positioned as an interactive assistant rather than a simple function call within the spreadsheet grid.
- •Enterprise customers with existing workbooks containing the '=COPILOT()' function will receive automated prompts to migrate their workflows to the side pane interface to prevent formula errors.
📊 Competitor Analysis▸ Show
| Feature | Microsoft Copilot (Excel) | Google Gemini (Sheets) | Rows (AI) |
|---|---|---|---|
| Integration | Deeply embedded in M365 | Native to Google Workspace | Built-in AI analyst |
| Pricing | Per-user subscription | Included in Workspace AI | Tiered/Usage-based |
| Primary AI Mode | Side pane / Agentic | Side panel / Formula help | Integrated AI columns |
🛠️ Technical Deep Dive
- The =COPILOT() function relied on a direct API bridge between the Excel calculation engine and the underlying LLM (likely GPT-4o or successor models).
- The side pane utilizes a more robust context window, allowing the model to ingest larger ranges of data, metadata, and workbook structure compared to the limited input parameters of a cell function.
- The shift reduces the overhead on the Excel calculation chain, as the side pane operates asynchronously, preventing the 'blocking' behavior often associated with complex AI-driven cell calculations.
🔮 Future ImplicationsAI analysis grounded in cited sources
Microsoft will prioritize 'Agentic' workflows over formula-based AI.
The removal of the function signals a strategic pivot toward multi-turn, stateful interactions rather than stateless, single-shot formula execution.
Excel will see increased integration with Microsoft's autonomous agent framework.
Moving functionality to the side pane allows for better integration with persistent agents that can perform tasks across multiple Office applications.
⏳ Timeline
2023-03
Microsoft announces Copilot for Microsoft 365, including Excel integration.
2023-11
Copilot for Microsoft 365 becomes generally available for enterprise users.
2024-06
Microsoft introduces advanced data analysis features in Excel via the Copilot side pane.
2026-08
Microsoft officially retires the =COPILOT() worksheet function.
📰
Weekly AI Recap
Read this week's curated digest of top AI events →
👉Related Updates
AI-curated news aggregator. All content rights belong to original publishers.
Original source: The Register - AI/ML ↗