Between July and September 2026, two tools that analysts use daily changed in ways worth knowing about. Microsoft removed the experimental COPILOT function from Excel, and Google’s Looker moved several conversational analytics features to general availability while previewing data agents on dashboards.

Facts in this article were checked against Microsoft Support, the Microsoft Excel blog and Google Cloud’s Looker release notes in October 2026.

Excel: the COPILOT function is gone

Microsoft’s support page for the COPILOT function now carries a clear notice: starting 14 September 2026, the COPILOT function is no longer available in Microsoft Excel. The function had only been available as a preview through the Frontier and Microsoft 365 Insider programmes.

What this means in practice:

  • Any cell that used =COPILOT() is no longer recognised and returns a #NAME? error when the workbook recalculates.
  • Microsoft points users to the Copilot pane in Excel instead, which it says supports summarising text, classifying data, generating content and looking up information from the web.
  • If you built a workbook for a client or manager using the function, replace those cells with static values or with standard formulas before it is shared again.

The lesson is a familiar one: preview features can be withdrawn. Do not build production reports on them.

Excel: other changes from the Microsoft Excel blog

The Excel team’s blog posted several updates in this period. Based on the official post titles and summaries:

Date (2026)PostWhat it covers
6 AugustBring your organization’s data into Excel with new Copilot synced connectorsBringing data from business systems such as an engineering backlog, ticketing system or CRM into Excel through Copilot
Late AugustWhat’s New in Excel (August 2026)Monthly feature round-up
1 SeptemberCopilot in Excel: Bringing clarity to collaborative workbooksUsing Copilot to understand workbooks that many people edit
24 SeptemberExcel now supports multiple values in a single cellLists, arrays in cells and nested arrays as new ways to keep related data together
29 SeptemberWhat’s New in Excel (September 2026)Monthly feature round-up

The “multiple values in a single cell” change is the one to watch. Many analysts have spent years splitting comma-separated values out of single cells. A native way to store lists inside a cell could change how some data is shared, though analysts should check how such cells behave when exported to CSV or loaded into Power BI or SQL before relying on them.

Earlier in the year, on 22 April 2026, Microsoft announced that Copilot’s agentic capabilities in Word, Excel and PowerPoint were generally available. In Excel, that means Copilot can explore data, build and explain analysis and make changes directly in a workbook. Microsoft said this is available to Microsoft 365 Copilot and Microsoft 365 Premium subscribers, and to Personal and Family plans.

Looker: data agents and verified queries

Google’s Looker release notes for the same months show steady progress on conversational analytics, Looker’s natural-language question-answering feature:

Date (2026)ChangeStatus
30 JulyDefine and chat with data agents on a LookML dashboardPreview
5 AugustCustom calendars, Expression Assistant and enhanced searchGenerally available
5 AugustAdmin Assistant for managing Looker roles in natural languagePreview
28 AugustConversational Analytics verified queries, now also definable in Looker (Google Cloud core)Generally available
28 AugustVisual modeling canvas for building and editing LookML models on BigQuery dataPreview
30 SeptemberEnhanced observability metrics for Conversational Analytics, including usage and estimated token dataGenerally available

“Verified queries” deserve attention. They let a team mark a known-good query as the trusted answer to a business question, so an AI assistant can reuse it rather than generate a fresh, possibly wrong, query each time. It is a practical way of putting human checking into an AI workflow.

A quick audit for shared workbooks

If you manage templates or recurring reports in Excel, a short audit now avoids surprises later:

  • Use Find (Ctrl+F) with “Look in: Formulas” to search each workbook for “COPILOT(” and replace any hits.
  • List any workbooks that depend on other preview or Insider-only features, and decide whether they should be rebuilt with standard functions.
  • Check whether Python in Excel cells will work for every recipient. People on unsupported platforms, such as the iPad, iPhone and Android apps, cannot run them.
  • Before you adopt lists or arrays inside cells, test how they export to CSV and how Power BI or your database reads them.

What analysts should take from this

  1. Treat preview features as experiments. The COPILOT function’s removal shows that even widely discussed features can disappear.
  2. Get comfortable checking AI output. Verified queries in Looker and Q&A checks in other tools all assume a human defines and tests the “right” answer.
  3. Keep learning the fundamentals. Formulas, PivotTables, Power Query, SQL and LookML are what AI features sit on top of.
  4. Note what your licence includes. Many Excel AI features depend on Microsoft 365 Copilot or specific consumer plans. Python in Excel, for example, is available to Enterprise and Business users on supported Windows, Mac and web versions, with a paid add-on for faster “premium” compute.

Frequently asked questions

My old workbook shows #NAME? errors. Is it the COPILOT function?

If the affected cells used =COPILOT(), yes. Microsoft says the function stopped working from 14 September 2026 and those cells return #NAME? on recalculation. Replace them with values or standard formulas.

Is Looker widely used in India?

Looker is part of Google Cloud and works closely with BigQuery, so it tends to appear in companies that run their data on Google Cloud. Before investing heavily in it, search job listings in your target city and sector and compare how often Looker appears next to Power BI and Tableau.

Do I need Microsoft 365 Copilot to use Copilot in Excel?

Microsoft said the agentic Copilot features in Excel are available to Microsoft 365 Copilot and Microsoft 365 Premium subscribers, and to Personal and Family plans. Workplace access depends on what your employer licenses.

Official sources

Leave a Reply

Trending