🇨🇳cnBeta (Full RSS)•Freshcollected in 17m
Microsoft Retires Excel’s COPILOT() Function
💡Excel AI workflows built on COPILOT() have a firm 2026 retirement deadline—start planning the migration now.
⚡ 30-Second TL;DR
What Changed
Excel’s COPILOT() function will be retired on September 14, 2026.
Why It Matters
Teams that built workflows around the worksheet function may need to revise formulas, documentation, and user training. The long retirement window provides time to test Microsoft’s replacement entry points before the deadline.
What To Do Next
Inventory every workbook using COPILOT(), flag those used in production, and test Microsoft’s replacement Excel entry points before September 14, 2026.
Who should care:Enterprise & Security Teams
Key Points
- •Excel’s COPILOT() function will be retired on September 14, 2026.
- •The decision follows a one-year test with Frontier and Insider customers.
- •Microsoft plans to move the functionality into other Excel entry points rather than remove the underlying capability entirely.
🧠 Deep Insight
AI-generated analysis for this event.
🔑 Enhanced Key Takeaways
- •The COPILOT() function was originally introduced as a specialized formula-based interface allowing users to invoke generative AI directly within a cell, similar to how traditional functions like SUM() or VLOOKUP() operate.
- •User feedback from the Frontier and Insider programs indicated that the formula-based approach caused significant 'context switching' friction, leading Microsoft to prioritize the Copilot side pane and ribbon integration.
- •Microsoft is transitioning the underlying logic to a more robust 'Copilot in Excel' architecture that supports multi-turn reasoning and persistent data analysis rather than single-cell formula execution.
- •The retirement is part of a broader 'Unified AI Interface' initiative across the Microsoft 365 suite, aimed at standardizing how users interact with Copilot across Word, PowerPoint, and Excel.
- •Existing workbooks containing the COPILOT() function will require manual migration or will be automatically converted to static values or error states depending on the specific implementation version after the September 14 deadline.
📊 Competitor Analysis▸ Show
| Feature | Microsoft Copilot (Excel) | Google Gemini (Sheets) | Rows (AI Analyst) |
|---|---|---|---|
| Primary Interface | Side Pane / Ribbon | Side Panel / Magic Wand | Integrated AI Analyst |
| Data Context | Deep M365 Integration | Workspace / Drive | External API / Database |
| Formula Generation | Advanced (Python/M) | Basic (Apps Script) | Advanced (SQL/Python) |
🛠️ Technical Deep Dive
- The COPILOT() function operated by sending cell references and context to the Microsoft Graph and Azure OpenAI service via a proprietary API wrapper.
- The transition moves functionality from a synchronous formula-evaluation model to an asynchronous event-driven model triggered by the Excel Object Model (EOM).
- The new architecture utilizes the 'Copilot Runtime' which maintains stateful sessions for data analysis, overcoming the stateless limitations of the previous cell-based function.
- Integration relies on the Microsoft 365 Copilot service architecture, leveraging semantic indexing to provide context-aware responses without requiring explicit cell-range inputs.
🔮 Future ImplicationsAI analysis grounded in cited sources
Microsoft will deprecate all remaining formula-based AI entry points by Q2 2027.
The shift away from COPILOT() signals a strategic move toward UI-based AI interaction models that offer better performance and user experience.
Excel's reliance on Python-in-Excel will increase as a result of this change.
By moving away from the COPILOT() function, Microsoft is steering power users toward Python-in-Excel for complex data analysis tasks that require programmatic control.
⏳ Timeline
2023-03
Microsoft announces the initial integration of Copilot into Microsoft 365 apps.
2025-08
Microsoft launches the COPILOT() function for Excel in the Frontier and Insider channels.
2026-05
Microsoft begins telemetry collection on COPILOT() usage patterns to evaluate user adoption.
📰
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: cnBeta (Full RSS) ↗