Microsoft adds live Copilot formulas to Excel cells
Reviewed by Helen Jones
Microsoft rolled out the =COPILOT() worksheet function that accepts plain-language prompts and recalculates when source data changes. The same update adds one-click pivot table and chart creation, column cleanup, and formula explanation. These features require the paid Microsoft 365 Copilot license. Free Copilot Chat no longer connects to desktop Excel after April 2026. Data must sit in tables for reliable results. Some advanced Agent and Plan modes remain in preview.
Before this change, Copilot suggestions lived in a side pane where an analyst could read, test, and discard them without touching the actual workbook. The new function writes directly into cells that update automatically, so any error or hallucination travels straight into the numbers that feed reports and dashboards. The practical effect is that the verification step now sits between the AI output and every downstream consumer of the report. Analysts who skip that step will discover the mismatch only when a stakeholder questions a total that no longer matches the source system.
Analysis
Stop treating Copilot output as draft material that someone else will check. Build a one-page verification checklist that forces you to compare every generated formula or summary against the original source table and the agreed KPI definition before the file is shared.
Pulse published by Collab365 Spaces, reviewed by Helen Jones on . Cite as "Microsoft adds live Copilot formulas to Excel cells", Collab365 Spaces. 1 source referenced.