Microsoft Retires Excel =COPILOT Function Today: What Replaces It and What Users Should Do
Microsoft is retiring the experimental =COPILOT function in Excel on September 14, 2026. If you used the formula-style AI feature inside spreadsheet cells, the change is important: Microsoft says the function will no longer be available, while Copilot in Excel remains accessible through the Copilot side pane.
This is not the end of AI in Excel. It is a change in how Microsoft wants users to access it. The company is moving away from an AI formula that recalculates inside the grid and toward the broader Copilot experience that can analyze, summarize and help edit workbook data from a dedicated interface.
What exactly is Microsoft removing?
The COPILOT function was designed to let users type an AI prompt directly into an Excel formula and reference cells as context. In preview, it could help summarize text, categorize entries, brainstorm content and generate natural-language outputs without leaving the grid.
Microsoft’s own support page now carries a clear notice that the function is no longer available starting September 14. The feature had been offered through preview programs rather than positioned as a permanent, universal Excel function. That distinction matters because businesses should be cautious about building production-critical workflows around preview features without a fallback.
What replaces =COPILOT?
Microsoft points users to Copilot in Excel through the side pane. The side-pane experience can handle many of the same high-level jobs: summarizing information, classifying data, generating content and answering questions about a workbook.
The biggest difference is architectural. A worksheet function behaves like part of the calculation grid. A side-pane assistant behaves more like a collaborator that examines the workbook and helps you perform tasks. That can be more flexible, but it is not a one-for-one replacement for every formula that depended on AI output updating automatically inside a cell.
What happens to workbooks that already use the function?
If a workbook depends on =COPILOT, treat it as a workflow that needs review rather than assuming it will continue indefinitely. Microsoft’s notice says the function will no longer be available. The safest approach is to identify every workbook using it, document what the formula was doing, and replace that behavior with a supported method.
- Search important workbooks for formulas containing COPILOT.
- Record the prompt, referenced range and expected output.
- Convert critical AI-generated results to static values if they must be preserved.
- Decide whether the task belongs in Copilot’s side pane, a standard Excel formula, Power Query, Office Scripts or another supported automation.
- Test the replacement on a copy before changing a production workbook.
Five practical replacements for common =COPILOT jobs
1. Summarizing comments or survey responses
Use Copilot in Excel’s supported interface to summarize a selected table or range. For repeatable reporting, keep the raw data structured in an Excel Table so the assistant has a consistent source.
2. Categorizing rows
If categories follow explicit rules, a regular formula may be more reliable than generative AI. SWITCH, IF, XLOOKUP and lookup tables are easier to audit. If classification genuinely requires language understanding, use Copilot interactively and validate the results before treating them as business data.
3. Cleaning imported data
Power Query remains a stronger choice for repeatable transformations such as splitting columns, changing data types, removing duplicates and combining files. AI is useful for helping design a cleanup process, but deterministic tools are preferable when the same transformation must run the same way every time.
4. Generating text from rows
For one-off text generation, the side pane may be enough. For high-volume or regulated output, consider a controlled automation with review steps instead of relying on a volatile preview formula.
5. Repetitive workbook actions
Office Scripts or other supported Microsoft automation tools can be a better fit when the task is procedural rather than creative. The key question is whether you need AI reasoning or simply repeatable spreadsheet logic.
Why would Microsoft remove a feature that sounded so useful?
Microsoft has not framed the retirement as a rejection of AI-powered spreadsheets. In fact, its guidance points users to the broader Copilot experience. The likely product logic is that a side-pane assistant gives Microsoft more control over context, user interaction, safeguards and feature evolution than a generative function embedded directly in Excel’s calculation engine.
Formula cells also create difficult expectations. Users expect spreadsheet formulas to be reproducible, auditable and predictable. Generative AI outputs can vary. That tension is manageable for brainstorming, but it becomes more complicated in financial models, operations dashboards or regulated workflows where a value must be explainable months later.
What business users should do today
- Inventory: find spreadsheets that use preview AI features.
- Preserve: save important generated outputs before changing the workbook.
- Replace: move repeatable logic to supported formulas, Power Query or scripts when possible.
- Validate: keep human review for AI-generated classifications, summaries and text.
- Document: record which Microsoft 365 license and Copilot features a workflow requires.
The bigger lesson: do not confuse AI previews with permanent infrastructure
The retirement is a useful warning for the wider AI era. Fast-moving products can appear, change and disappear much faster than traditional office features. Businesses should experiment, but production systems need fallbacks, ownership and documentation.
The same principle applies beyond Microsoft. New frontier models such as GPT-6 Astra may unlock powerful workflows, but teams still need to design processes around stable interfaces and verified outputs rather than around hype alone.
FAQ
Is Copilot being removed from Excel?
No. Microsoft is retiring the =COPILOT worksheet function, not the broader Copilot experience in Excel. Microsoft directs users to Copilot in Excel through the side pane.
When is the Excel COPILOT function retired?
Microsoft says it will no longer be available starting September 14, 2026.
Should companies use preview AI features in critical spreadsheets?
Only with a fallback and review process. Preview features can change, and generative outputs should not be treated as deterministic business logic without validation.
Sources and references
You may also like
- GPT-6 Astra Explained: Features, Price and Availability
- AI Slowdown 2026: Why Tech Stocks Fell
- Microsoft September 2026 Patch Tuesday: What Windows Users Should Do
Illustrative image credits: Windows, Bram Van Oost and Surface via Unsplash.
