Spreadsheets have quietly become one of the biggest testing grounds for generative AI, and Excel Copilot sits at the center of that shift. Whether you're cleaning messy data, drafting formulas, or summarizing a thousand-row table in seconds, Microsoft's AI assistant is changing how everyday users interact with the grid. But the way people access that intelligence inside Excel is evolving fast — and anyone relying on Excel automation should understand exactly where things stand.

From Formula Bar to Side Pane

For the past year, Microsoft tested a natural-language =COPILOT() worksheet function that let eligible users type a plain-English prompt into a cell, reference other cells or ranges, and get an AI-generated response back — everything from brainstorming marketing copy to summarizing long text passages. The function allowed users to enter a natural language prompt in a spreadsheet, reference cell values, and generate results directly in the grid. It was popular for tasks like spurring ideas, generating SEO keyword sets, rewriting messaging, and distilling large data ranges or long passages into concise summaries.

That formula-based experiment is now ending. Beginning September 14, 2026, the COPILOT() function will no longer be available, and Microsoft had originally planned to make it generally available sometime in 2027. According to Microsoft's own messaging, the change is meant to streamline the Copilot experience in Excel while continuing to provide AI assistance through a supported interface, and customers can keep using Copilot in Excel through the Copilot side pane.

This matters because the function had never actually reached general availability. It remained limited to the Microsoft 365 Insider and Frontier channels and never shipped to public versions of Excel 365. If you were experimenting with it, the practical takeaway is simple: convert any COPILOT()-generated results to static values before the cutoff, since formulas that call the function will stop working.

Why Microsoft Pulled the Plug

The retirement isn't about the AI underperforming on qualitative tasks — reviewers noted it was genuinely capable at text summarization, classification, generation, and web lookups. Its limitations were more structural. Microsoft never recommended it for numerical calculations, in-workbook data lookups, or content involving legal or compliance requirements, and it required both a live internet connection and a Microsoft 365 Premium subscription. There were also practical throughput limits: the function was capped at roughly 100 calls every ten minutes, which made anything beyond a small table slow going.

Rather than continue refining a standalone formula, Microsoft is consolidating AI access into fewer, centrally managed entry points. Today that means the Copilot side pane and, on some builds, a floating in-grid launcher — users can continue working with Copilot through both the Copilot side pane and the floating Dynamic Action Button, which makes a dedicated function somewhat redundant in Microsoft's view.

What This Means for Everyday Excel Users

If you never touched the Insider or Frontier channels, this change likely won't affect your day-to-day workflow at all — the mainstream Copilot side pane remains fully available and keeps expanding. It's still the go-to place for describing what you want in plain language, generating formulas, explaining existing ones, cleaning up datasets, building quick charts, or getting a narrative summary of a complex tab.

The bigger lesson is a general one for anyone building serious workflows around AI-powered Excel features: preview functionality is exactly that — a preview. Workbooks that leaned on COPILOT() now need to migrate to native formulas, Power Query, scripts, or another approved alternative. Treat experimental AI formulas as helpful for prototyping, not as something to embed permanently into reports that other people depend on.

For teams that specifically want AI logic living inside a recalculating formula — something that updates automatically as inputs change, rather than a one-off chat response — third-party add-ins have emerged to fill that gap, offering formula-style functions that call various AI models directly from cells without the same rate limits.

Getting the Most Out of Copilot in Excel Going Forward

Use the side pane for exploratory work: summarizing ranges, spotting trends, drafting formulas, or asking "why did this number change?"
Keep AI-touched calculations out of files where accuracy and auditability are critical, and always spot-check generated formulas before trusting them.
Watch your license type, since full Copilot functionality generally requires a qualifying Microsoft 365 Copilot subscription.
Stay current on Microsoft's roadmap — AI features in Excel have moved and been renamed quickly over the past year, and what's "in preview" today may look different by next quarter.

AI in spreadsheets isn't slowing down — it's being reorganized. Understanding where Microsoft is investing (the side pane, contextual AI actions) versus what it's winding down (the standalone formula) will save you from building workflows on features that won't be there next quarter.

FAQs

Q1.Is the Excel COPILOT() function still usable?
Only until September 14, 2026, and only for users on the Microsoft 365 Insider or Frontier channels — it never reached general availability for mainstream Excel 365 users.

Q2.What should I use instead of the COPILOT() formula?
For most tasks, the Copilot side pane covers the same ground — summarizing, classifying, and generating content. For AI logic that needs to live inside a recalculating formula, look at native Excel functions, Power Query, or a dedicated AI add-in.

Q3.Do I need a special license to use Copilot in Excel?
Yes, most AI features require a qualifying Microsoft 365 Copilot subscription, and some capabilities also depend on an active internet connection.

Q4.Will my old COPILOT() formulas break after the retirement date?
Yes. Any workbook still calling the function will return errors after September 14, 2026, so it's worth converting existing results to static values now to avoid disruption.