AI-assisted research, source-checked and reviewed by a human editor. How we work
Excel COPILOT Function Removed: What to Use Instead
If an Excel workbook that previously used =COPILOT() now shows #NAME?, you may be seeing a product change rather than a typo in your formula. Microsoft says the preview COPILOT function stopped being available in Excel on September 14, 2026. Existing calculated results may remain as cached values, but formulas that recalculate are no longer recognized.
The change matters for anyone who experimented with AI summaries or classification directly inside spreadsheet cells. The current replacement is not another identical worksheet function: Microsoft directs users to Copilot in Excel through the Copilot pane. This guide explains the difference, how to inspect affected workbooks, which tasks can move to the newer interface, and where ordinary Excel formulas remain the better answer. The product details below were checked against Microsoft’s documentation on October 24, 2026.
What happened to the Excel COPILOT function?
The COPILOT() worksheet function was a preview feature offered through the Frontier and Microsoft 365 Insider programs. It let eligible users provide a prompt and references to cells and receive a language-model-generated result in a worksheet cell. According to Microsoft’s official function documentation, it was removed beginning September 14, 2026 and is no longer available in Microsoft Excel.
That is different from saying “Copilot in Excel is gone.” The broader Copilot experience remains available through an interface that can analyze data, propose or create formulas, summarize text, and help work with tables and charts. Availability depends on the user’s subscription, organization settings, app version, and applicable feature rollout.
For teams with shared workbooks, the important step is identifying where the retired function was used and deciding whether each use case needs a standard formula, a manual Copilot action, or a more controlled automation.
Why an old =COPILOT formula may return #NAME?
Excel uses #NAME? when it does not recognize something in a formula, including an unavailable function name. Microsoft’s specific documentation for the retired function says a cell containing =COPILOT(...) will return that error when it recalculates because the function is no longer recognized. Previously calculated results may remain as cached values until recalculation.
This means two copies of the same workbook may appear different depending on whether results have refreshed. Do not treat visible old outputs as proof that the function still works. Equally, do not assume that every #NAME? cell is caused by this change; other invalid names and unsupported functions can produce similar symptoms.
How to check a workbook safely
- Save a separate copy of the original file. Avoid experimenting on the only copy of an important workbook.
- Use Excel’s Find feature to search formulas for
COPILOT(. Search the whole workbook, not just the active sheet. - Document each affected cell, worksheet, and the business purpose of the old output.
- Check downstream formulas, charts, PivotTables, or exports that rely on the affected cells.
- Decide whether the output should be a repeatable mathematical formula, a human-reviewed AI summary, or a separate analysis artifact.
For financial, payroll, regulatory, or other consequential workbooks, have an authorized reviewer reconcile all affected results against trusted source data before using them in decisions.
What to use instead of =COPILOT()
Microsoft’s Copilot data-insights guidance describes entering natural-language requests in the Copilot interface. You can ask for summaries, outliers, formula suggestions, lookups, PivotTables, and other analysis. The available controls and layout may differ by Excel app and subscription.
| Old goal | New approach to consider | What to verify |
|---|---|---|
| Summarize survey responses in cells | Ask Copilot to summarize a specified text column | Check examples, missing responses, and nuance |
| Classify feedback into topics | Ask Copilot to create a category column | Spot-check labels and ambiguous cases |
| Calculate profit margins | Use a standard Excel formula, with Copilot help if needed | Formula references, zeros, and currency assumptions |
| Look up inventory values | Use XLOOKUP or another deterministic formula | Missing keys, duplicates, and match mode |
| Find trends or outliers | Ask Copilot for a chart, PivotTable, or data insight | Source range, aggregation, and interpretation |
The key distinction is persistence. A normal Excel formula can recalculate under known rules when source values change. An AI-generated summary may be a contextual analysis that needs human review and may not behave as a continuously recalculating worksheet function. Design your workflow around that difference.
How to use the Copilot pane for spreadsheet analysis
Microsoft’s current guide says you can open Copilot using its icon in the lower-right area of Excel, where supported. From there, ask a specific question about the workbook. For example:
In the CustomerFeedback table, categorize each response in the Feedback column as delivery, product quality, billing, or other. Create a new category column. Flag ambiguous responses for manual review, and do not change the original feedback text.
This is more useful than “analyze my spreadsheet” because it identifies the source, task, output, categories, and uncertainty rule. After Copilot responds, review the suggested changes before applying them. Inspect any new columns, formulas, or tables directly in Excel.
Ask Copilot to explain an inherited formula
If you encounter a complicated formula you did not write, select that cell and ask Copilot to explain it. Microsoft lists formula explanations among supported workflows. Use the explanation to guide your own test, not as unquestioned proof that the expression is correct.
Ask for a formula rather than an AI answer
For numeric calculations, request a normal Excel formula. For example: “Add a Profit Margin column using (Revenue minus Cost) divided by Revenue; handle zero revenue without displaying a division error.” Inspect the formula Copilot proposes, test boundary cases, and confirm that any handling of missing or zero values matches your organization’s reporting rules.
When ordinary Excel formulas are better
Many tasks do not require an AI model once you understand the calculation. Use SUM, IF, SUMIFS, XLOOKUP, date functions, or PivotTables when the desired operation is deterministic. These tools make it easier to reproduce a result, trace references, and audit changes.
AI assistance may be useful for explaining a complicated transformation, creating a starting formula, or exploring text-based themes. It should not replace explicit business logic for tax calculations, payroll deductions, accounting rules, or other sensitive decisions. Microsoft also warns that AI-generated outputs may be mistaken or inaccurate.
A simple review example
Suppose a worksheet has a monthly sales total of 12,000 and costs of 9,000. The profit is 3,000, and a margin calculated as profit divided by sales is 25%. A formula such as =(B2-C2)/B2 can express that operation if the cells and assumptions match your workbook. A reviewer should still check whether costs include all required items and whether the source numbers are correct.
Now compare that with asking an AI to infer a sentiment category from a customer review. That output involves interpretation, not a fixed arithmetic rule. It calls for sample-based validation, defined categories, and a way to manage uncertain results.
Important access and workbook requirements
Do not assume Copilot appears in every copy of Excel. Microsoft’s getting-started guidance says availability can depend on licensing and organization settings. A Microsoft 365 FAQ notes that certain subscription experiences require AutoSave and a workbook saved to OneDrive. Microsoft’s Copilot in Excel FAQ also lists automatic calculation as a requirement for supported editing and warns that Copilot can make direct workbook changes visible to collaborators.
Before planning a migration, check the actual app, subscription, file location, AutoSave state, and organization controls. Save a copy or use version history before making broad changes. If Copilot is unavailable, use native Excel tools or request the appropriate access through your administrator; do not purchase or enable a new plan solely on the assumption that it duplicates the removed function.
How to migrate a workbook used by a team
For one workbook, a manual audit may be enough. For a recurring reporting process used by several people, document the transition:
- Inventory: Search all formulas for the retired function and list affected outputs.
- Classify: Separate deterministic calculations from interpretation or summarization tasks.
- Replace: Use standard formulas where possible; move AI-assisted analysis to a reviewed Copilot interaction where appropriate.
- Validate: Compare replacement outputs with independently checked source records, including edge cases.
- Communicate: Tell workbook users which cells changed and which outputs now require a manual refresh or review.
- Monitor: Recheck dependent reports after the next normal reporting cycle.
Avoid silently pasting a static AI summary into a cell that colleagues expect to update automatically. Label manually generated or reviewed outputs with an as-of date when that helps prevent confusion.
Five verification tests after migration
- Normal input: Does the replacement work for a representative row or data set?
- Blank data: What happens when the source cell is missing?
- Unexpected value: What happens with unusual dates, negative values, or very long text?
- Changed source: Does the replacement update when data changes, or must someone rerun analysis?
- Downstream dependency: Do charts, summaries, exports, and linked workbooks still behave correctly?
Document failures and the corrections made. For AI-generated explanations or interpretations, also compare a sample against the original source. ThriftBeam’s AI fact-checking workflow offers a general method for reviewing AI-produced claims, while the AI code review guide outlines relevant testing habits when a generated formula becomes part of a larger automated process.
Frequently asked questions
Is the Excel COPILOT function still available in 2026?
Microsoft says the preview worksheet function was removed starting September 14, 2026. The broader Copilot in Excel interface is a separate product capability.
Why do older COPILOT formulas show #NAME?
The retired function is no longer recognized during recalculation. Previously cached results can sometimes remain visible until recalculated.
Can Copilot in Excel still generate formulas?
Microsoft documents formula-generation and explanation features through Copilot in Excel, subject to the current subscription and application requirements.
Does the Copilot pane automatically replace every =COPILOT formula?
No. It offers alternative workflows, not a one-to-one automatic conversion of every retired worksheet formula. You need to assess each use case.
Should I trust Copilot’s formula explanations without checking?
No. Review actual cell references, assumptions, sample results, and edge cases. Microsoft cautions that AI-generated suggestions can contain errors.
The bottom line
The removal of the Excel COPILOT() function means old preview formulas need attention, especially in workbooks that recalculate or feed other reports. Microsoft recommends using Copilot in Excel through the pane for AI-assisted tasks. For repeatable calculations, standard Excel formulas often remain the stronger choice.
Next step: Open a copy of your most important workbook, search for COPILOT(, and create a short list of affected cells before changing anything. That inventory is the quickest route to a controlled migration.
Editorial disclosure: This article was prepared with AI assistance and checked against linked official documentation. It is not based on first-hand product testing.
Sources and verification
- Microsoft — COPILOT function retirement notice
- Microsoft — Get data insights with Copilot in Excel
- Microsoft — Copilot in Excel FAQ
- Microsoft — Get started with Copilot in Excel
- Microsoft — Microsoft 365 Copilot subscription FAQ
