Microsoft is discontinuing the COPILOT() function in Excel, less than a year after introducing the AI-powered formula to Microsoft 365 subscribers, according to a report from Windows Report. The function let users embed generative AI prompts directly inside spreadsheet cells, producing text summaries, classifications, and analysis alongside traditional formulas like SUM or VLOOKUP.
Microsoft has told users the function is being phased out and has pointed them toward other AI tools already built into the Excel ribbon and sidebar, rather than a formula-based approach. The company has not published a detailed public explanation for the reversal, but the timeline is notable: COPILOT() was still in preview for much of its short life and never fully graduated to general availability across all Microsoft 365 plans.
What COPILOT() Was Supposed to Do
When Microsoft rolled out COPILOT() in Excel, the pitch was straightforward: bring generative AI into the same cell-and-formula logic that has defined spreadsheets for decades. Instead of switching to a chat pane to ask a question about a dataset, users could type something like =COPILOT("Summarize the trend in this range", A2:A50) and get an AI-generated response returned as a cell value, updating dynamically as the underlying data changed.
The feature was aimed at power users building dashboards and reports who wanted AI output to behave like any other calculated value — sortable, referenceable, and able to feed into downstream formulas. It represented one of Microsoft’s more ambitious attempts to fuse large language model output with the deterministic, auditable world of spreadsheet computation.
Why It’s Being Pulled
Reports indicate the function ran into practical limitations that made it a poor fit for how spreadsheets are actually used. AI-generated text is probabilistic — the same prompt can return slightly different wording on each recalculation — which clashes with the expectation that a spreadsheet formula produces consistent, reproducible results. For financial models, audit trails, and shared workbooks where consistency matters, a formula that could silently change its output on refresh created real risk.
There were also concerns about cost and performance at scale. Each COPILOT() call effectively triggered a model inference request, meaning a worksheet with hundreds or thousands of instances of the function could generate significant backend load and licensing costs compared with a single chat-based query covering the same ground. Rather than continue refining the formula approach, Microsoft appears to be consolidating its AI investment into the broader Copilot experience already embedded in Excel’s interface, including natural-language query panes and AI-assisted chart and formula suggestions that don’t require rewriting cell logic.
Impact on Users
The retirement leaves some Microsoft 365 subscribers needing to audit and rebuild spreadsheets that incorporated the function into recurring reports. Because COPILOT() output was often used in dashboards refreshed on a schedule, businesses that adopted it early may need to replace those cells with static text, alternative formulas, or workflows routed through Copilot’s chat interface instead.
Microsoft has generally given users a transition window in similar past deprecations, and the company is expected to provide guidance on migrating existing workbooks before the function is fully removed. Still, the episode underscores a pattern familiar to enterprise software customers: features tied to generative AI are being iterated on far faster than traditional Office functionality, which historically remained stable for years or even decades.
Part of a Broader AI Iteration Cycle
The quick reversal reflects the pace at which large tech companies are testing and abandoning AI features as they figure out which integrations actually stick. Microsoft has pushed Copilot branding across its entire productivity suite over the past two years, embedding it in Word, Outlook, Teams, and Excel, while continuing to adjust how each implementation works based on user feedback and internal performance data.
The COPILOT() function’s short lifespan also comes as major AI labs and their corporate partners debate the practical value of generative tools versus their cost and reliability. Anthropic CEO Dario Amodei has argued that AI needs to deliver undeniable real-world breakthroughs to secure lasting public trust, a bar that formula-level novelties like COPILOT() were unlikely to clear on their own. Meanwhile, the U.S. government has been pressuring allies to standardize on American AI infrastructure, of which Microsoft’s Copilot ecosystem is a central pillar, adding commercial pressure for the company to demonstrate features that clearly work rather than ones requiring frequent walk-backs.
For now, Excel users relying on COPILOT() should expect Microsoft to publish migration guidance and a firm cutoff date in the coming weeks. Those building new AI-assisted spreadsheets are being steered toward Copilot’s chat and sidebar tools, which Microsoft frames as more stable and better suited to iterative, conversational analysis than a single-cell formula ever could be.
