Copilot in Excel reached general availability without a table rule

General availability on 16 September 2024

Microsoft's Wave 2 announcement states that Copilot in Excel became generally available on 16 September 2024, after a period in preview. The same post lists what changed: Copilot can now work with data that has not been formatted as an Excel table, and it gained new skills including formulas such as XLOOKUP and SUMIF, conditional formatting, and the ability to iterate on charts and PivotTables through further prompts rather than a single request. The announcement also says Copilot in Excel can now read text as well as numbers. Read together, these are admissions as much as features: the phrase 'can now work with data that hasn't been formatted as a table' only makes sense if the earlier, preview version required a table to operate on.

How the workflow is described

Microsoft's support documentation for Copilot in Excel describes the mechanism as a plan, not a single transformation: Copilot 'analyzes your task and creates a step-by-step plan', then 'works directly in your workbook to carry out that plan'. A person is meant to review the plan and the result before accepting it, rather than treat the output as final. Access depends on an eligible Microsoft 365 subscription that includes Copilot; the same page notes that if Copilot does not appear in Excel, it might not be included in that subscription or might be turned off by an organisation's settings. The Wave 2 announcement also introduces a related but separate feature, Copilot in Excel with Python, combining natural-language prompts with the Python engine described elsewhere in this archive; Microsoft is explicit that this combination shipped in public preview, not general availability, which carries a different, earlier-stage reliability expectation than Copilot in Excel itself.

What neither document addresses

Neither the announcement nor the support page states how a generated formula should be checked before it is relied on, or what happens when Copilot's plan touches a cell a person did not expect it to touch. The support page's assurance that a user is 'in control of everything that's modified' describes permission, not accuracy: a person can decline a change, but the documentation does not say how to verify that an accepted XLOOKUP or a rewritten PivotTable did what was intended. That gap matters more, not less, once the table requirement is gone, because an unstructured range is exactly where a formula referencing the wrong row is hardest to notice at a glance.

• Does the Microsoft 365 licence in place actually include Copilot in Excel, or only base Excel?
• Is the workbook's data in a table, and if not, has a generated formula been checked against a manual calculation?
• Is the task one that needs Python-level analysis, which is still a public preview rather than a general-availability feature?

The headline of a general-availability announcement is usually the feature. Here it is closer to the exceptions being removed one at a time, table by table, data type by data type, with no public account yet of how reliably the resulting formulas hold up outside a demonstration.