Excel =COPILOT Is Being Retired: Replace AI Formulas Before September 14, 2026

A workbook may contain =COPILOT formulas for labels, short summaries, or text classification. That is convenient until the result becomes part of an operational report, handoff, or refresh process.

Microsoft has announced that the =COPILOT function will no longer be available starting September 14, 2026. The safest replacement is not one substitute for every prompt: save today’s outputs as values, replace rule-based work with normal Excel formulas, and move open-ended writing or analysis to the Copilot side pane. Microsoft’s retirement notice is available in its COPILOT function announcement update.

Quick Fix: Protect Your Workbook in Four Steps

1. Make a copy of the workbook before changing formulas.
2. On every worksheet, press Ctrl+F, search for =COPILOT(, select Options, and set Look in to Formulas.
3. For each confirmed result, copy the cell or range and use Paste Special > Values to preserve the current output.
4. Replace predictable classifications, lookups, and text extraction with standard formulas. Use Copilot chat for tasks that truly need a written response, then review and paste the approved result.

Do not paste values over the original formula until you have a backup. A saved value protects the current report, but it does not create a refreshable replacement.

1. Inventory Every =COPILOT Cell First

Start with an audit. A single =COPILOT formula can feed totals, charts, Power Query inputs, or downstream lookups. Replacing it without checking dependents can leave a workbook looking correct while its next update silently fails.

Find formulas worksheet by worksheet

1. Save a copy with a name such as Sales Report - pre-COPILOT migration.xlsx.
2. Select a worksheet and press Ctrl+F.
3. Enter =COPILOT(.
4. Select Options, choose Formulas in Look in, then select Find All.
5. Record the sheet name, cell address, prompt purpose, and where the result is used.

Repeat for each sheet. Searching for the opening parenthesis avoids matching a note that merely mentions the word “COPILOT.”

Sheet	Cell or range	Current job	Best replacement
Orders	D2:D500	Classify customer comments	Keyword rules or a lookup table
Products	F2:F200	Create category labels	XLOOKUP mapping table
Monthly review	B4	Write a management summary	Copilot chat, then human approval

Also check formulas that refer to the output cells. Select a result cell and use Formulas > Trace Dependents if you need to see what relies on it. This is especially useful before converting an entire column to values.

2. Preserve Current Outputs as Values

Use this as a short-term safety net. If a report must retain the wording or labels it has today, freeze those results before the retirement date.

1. Select the verified =COPILOT result cells.
2. Press Ctrl+C.
3. Right-click the same selection and choose Paste Special > Values.
4. Check a few cells in the formula bar. They should show text or numbers, not =COPILOT(...).

For an audit-friendly approach, keep two columns: Legacy AI Result and Replacement Result. Compare them during the next data refresh, then remove the legacy column only after sign-off.

3. Replace Deterministic AI Tasks with Formulas

Most cell-level AI prompts contain a hidden rule: match a product to a category, detect a known term, clean a code, or choose one of several statuses. These are better handled by formulas because they recalculate, can be checked, and give the same input the same answer.

For a practical comparison of where formulas should take over from AI, see when to use Copilot versus Excel formulas.

Example 1: Replace generated product labels with XLOOKUP

Suppose Products!B2:B6 contains a product family, and an old AI formula generated a reporting category. Put a controlled mapping table in H2:I5.

B: Product family	H: Family	I: Category
Router Pro	Router Pro	Networking
Office Chair	Office Chair	Furniture
Monitor 27	Monitor 27	Displays
—	Dock Mini	Accessories

In C2, enter:

=XLOOKUP(B2,$H$2:$H$5,$I$2:$I$5,"Review")

Fill down. Router Pro returns Networking; an unlisted family returns Review rather than an error. Add new approved mappings to the table instead of changing the formula.

This is the recommended method when labels come from a known list. If your choices depend on several conditions, the IFS, XLOOKUP, LET, and LAMBDA formula guide can help you choose a maintainable pattern.

Example 2: Replace simple comment classification with IFS

Suppose customer comments are in C2. You need a stable first-pass label: Refund, Delivery, or Other.

=IFS(C2="","",COUNTIF(C2,"*refund*")>0,"Refund",COUNTIF(C2,"*deliver*")>0,"Delivery",TRUE,"Other")

Enter the formula in D2 and fill down. A comment containing “refund” becomes Refund; one containing “delivery” or “delivered” becomes Delivery.

Order matters. If a comment can contain both terms, the first matching test wins. Keep a small list of real comments that should be reviewed manually rather than continually adding fragile keyword rules.

Example 3: Replace text cleanup with text functions

If an AI formula was extracting the department from a code such as UK-FIN-1042 in A2, use a text formula instead:

=TEXTBEFORE(TEXTAFTER(A2,"-"),"-")

The result is FIN. This is clearer and safer than asking AI to infer a consistent pattern. Test it against missing or differently formatted codes before filling down.

4. Move Genuine Generative Work to Copilot Chat

Do not force an Excel formula to imitate a writing task. A monthly narrative, a suggested explanation of an unusual trend, or a draft email needs context and judgment. Use Copilot in Excel’s chat experience for that work instead.

Microsoft documents Copilot in Excel’s edit, plan, and chat modes in its Get started with Copilot in Excel guidance. Treat the output as a draft, not an automatic cell calculation.

1. Create a small, checked input range containing the figures and labels Copilot needs.
2. Ask for a specific output, such as: “Draft three bullets explaining the largest month-on-month changes in this table. Do not invent causes.”
3. Check every number, name, date, and claim against the worksheet.
4. Edit the approved wording and paste it as a value into the report narrative area.
5. Record the reviewer and reporting date if the text is used externally.

Microsoft also advises users to review, edit, and verify AI-generated output in its data insights guidance. That review step is the replacement for trusting a cell formula to generate an unattended business decision.

Common Migration Mistakes

Issue	Cause	Solution
Only the visible result was checked	Search used values rather than formulas	Use Ctrl+F with Look in: Formulas.
Labels stop updating	Results were pasted as values with no replacement logic	Add a lookup table, text formula, or rule column.
New products return “Review”	The mapping list is incomplete	Add the approved item to the lookup table and document the owner.
Formula classification differs from old AI output	AI used contextual judgment; the rule is narrower	Create a Review category and define an escalation process.
A polished AI summary contains a wrong figure	The draft was not verified	Check statements against source cells before publishing.

Before September 14: Migration Checklist

• Back up every affected workbook.
• Find =COPILOT( formulas on every worksheet.
• Document each formula’s purpose and downstream use.
• Freeze any historical result that must remain unchanged.
• Replace fixed rules with formulas and controlled mapping tables.
• Test the replacement with normal, blank, new, and exception records.
• Move open-ended generation to Copilot chat and assign a reviewer.

If you need a structured checking process before deploying replacements, use this workflow for testing Copilot and formula results in Excel.

FAQ

Can I simply convert every =COPILOT result to values?

You can preserve the current result that way, but it will no longer update when source data changes. Use it for history or as a temporary safeguard, not as the full migration.

What is the best replacement for AI-generated categories?

Use XLOOKUP with a maintained mapping table when the permitted categories are known. Use an IFS or keyword formula only for simple, documented rules. Send unclear records to Review.

Should AI-generated summaries be placed back into formula cells?

No. Generate the draft in Copilot chat, verify it, then paste the approved wording as a value. This creates a deliberate review point.