Overview

• The new function lets users enter natural-language prompts with cell-range context to generate summaries, classifications, sentiment tags, and multi-column outputs that spill into the grid.
• Results can be combined with other Excel formulas and automatically recalculate when source data changes, with demos showing knowledge-based lists like airport codes and formatting via WRAPROWS.
• Access requires a paid Microsoft 365 Copilot license in the Insider Beta Channel on Windows Version 2509 (Build 19212.20000) or later or Mac Version 16.101 (Build 25081334) or later, with web rollout coming through the Frontier program.
• The release works only with data in the workbook and model knowledge, with no live web or enterprise document access yet as those integrations are planned for future updates.
• Usage is limited to 100 calls per 10 minutes (up to 300 per hour), and Microsoft notes early issues such as omitted rows in spilled arrays and dates returned as text, advising users to validate outputs.