Pinterest Pixel

Excel COPILOT Function Retired: What Happened and What to Use Instead

John Michaloudis
In 2025, Microsoft launched a new function called COPILOT.
It allowed users to perform AI-powered tasks directly within spreadsheet cells.

However, Microsoft retired this function on September 14, 2026.

In this article, you will learn why the Excel COPILOT function retired and what you can use instead.

In 2025, Microsoft launched a new function called COPILOT. It allowed users to perform AI-powered tasks directly within spreadsheet cells. However, Microsoft retired this function on September 14, 2026. In this article, you will learn why the Excel COPILOT function retired and what you can use instead.

Key Takeaways:

  • Microsoft retired the COPILOT function on September 14, 2026.
  • The function allowed users to perform AI tasks inside Excel cells.
  • Existing formulas will return a #NAME? error when refreshed.
  • You can use the Copilot pane for similar AI-powered tasks.
  • Regular Excel formulas are useful for calculations and data processing.

 

Introduction to the COPILOT function

What is COPILOT function?

The COPILOT function was introduced by Microsoft as a preview feature for Insider users. It is a text function where you can provide Excel with instructions inside a formula and use selected cells as context. The syntax of this function is:

=COPILOT(“Summarize these comments”, A2:A20)

  • COPILOT → the Excel function
  • “Summarize these comments” → your instruction
  • A2:A20 → the data the function should use

Excel COPILOT Function

This function can be used to do tasks like summarize text, highlight information, categorize data, generate lists, etc.

Why was the COPILOT Function Retired?

Microsoft found some limitations with the COPILOT function. Here are a few reasons why it was retired:

  • The same prompt could provide different answers.
  • When the model was updated, the same formula provided different results.
  • It could not read the web or your company’s documents.
  • The Copilot pane in Excel already does the same job and provides better results.
  • It has a low limit. You could run it only 100 times every 10 minutes, and 300 times an hour.

What will happen to the old workbook?

If you have an old workbook that contains the COPILOT function, there can be two situations:

  • If the file is not refreshed, it may show the results saved in the cache memory.
  • If the file is refreshed, the cell may return the #NAME? error. This can happen because the function no longer exists.

COPILOT Function Retired 2

The best option would be to copy the result and save it as a value before refreshing the file.

 

What to Use Instead of the COPILOT Function?

Use Copilot in Excel

You can now perform similar tasks using the Copilot pane. Simply enter your instructions in the chat box instead of writing a formula.

=COPILOT("Summarize this feedback", A2:A20)

Excel COPILOT Function

Open the Copilot pane and enter:

“Summarize the customer feedback in cells A2:A20 and highlight the three most common complaints.”

COPILOT Function Retired

To access Copilot in Excel, follow the steps below:

STEP 1: Open your Excel workbook.

COPILOT Function Retired

STEP 2: Select the Copilot icon in the lower-right corner of Excel.

COPILOT Function Retired

STEP 3: Enter your prompt in the Copilot chat box.

COPILOT Function Retired

STEP 4: Review the response and ask Copilot to make changes if required.

COPILOT Function Retired

Use Regular Excel Formulas

Instead of relying on AI, you can use the built-in formulas available in Excel.

  • SUM: Adds numbers in a range.

Sum Formula

  • IF: Returns results based on a condition.

How to Use IF Function in Excel - Step by Step Guide | MyExcelOnline

  • TEXTJOIN: Combines text from multiple cells.

How to Concatenate Cells and Strings in Excel - Step by Step Guide | MyExcelOnline

  • XLOOKUP: Searches for a value and returns matching information.

XLOOKUP Match Mode in Excel: Simple Tricks for Advanced Lookups | MyExcelOnline

  • COUNTIF: Counts cells that meet a specific condition.

How to do Data Analysis with COUNTIF Character Counts in Excel | MyExcelOnline

 

FAQs

1. Why was the COPILOT function retired?

The COPILOT function retired because Microsoft decided to move AI-powered tasks to the Copilot pane.

2. Can I still use the COPILOT function in Excel?

No. Microsoft retired the function on September 14, 2026.

3. What happens to existing COPILOT formulas?

They may show cached results or return a #NAME? error when recalculated.

4. What is the best alternative to the COPILOT function?

Many alternatives are available for the COPILOT function:

  • Copilot pane for AI-powered tasks
  • Regular Excel formulas for calculations
  • Power Query for data transformation.

5. Can I use regular Excel formulas instead of COPILOT?

Yes. You can use formulas like SUM, IF, and XLOOKUP for regular tasks.

If you like this Excel tip, please share it


Founder & Chief Inspirational Officer

at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  A Guide to Conditional Formatting with Copilot in Excel

Steps To Follow

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...