Important
- Starting September 14, 2026, the COPILOT function is no longer available in Microsoft Excel. The function was offered as a preview feature and was previously available only in theFrontier program and theMicrosoft 365 Insider program .
- You can continue to use Copilot in Excel through the Copilot pane, which supports many of the same AI-powered tasks, including summarizing text, classifying data, generating content, and looking up information from the web. To learn more, see Get started with Copilot in Excel .
The COPILOT function previously let you provide a prompt and references from the grid to generate a response from an AI language model directly in a cell. As of September 14, 2026, the function is no longer available, and this article is provided for reference.
What happens to existing workbooks #
If you have a workbook that used the COPILOT function, any results that were already calculated remain in the workbook as cached values. When a cell that contains the function recalculates, the function returns a #NAME? error because it's no longer recognized.
What to use instead #
Use Copilot in Excel and describe what you want in your own words. To open Copilot in Excel, select the Copilot icon in the lower-right corner of Excel. For more information, see Get started with Copilot in Excel. | Instead of the COPILOT function | Ask Copilot in Excel |
|---|---|
| =COPILOT("Summarize this feedback", A2:A20) | Summarize the feedback in A2:A20 |
| =COPILOT("Classify sentiment", B2:B100) | Classify each of the sentiment entries in B2:B100 and add the result in a new column | | =COPILOT("Look up upcoming holidays or major events in Seattle") | Look up upcoming holidays or major events in Seattle |