Particle.news

Download on the App Store

Excel Gains Built-In Copilot Function That Works Like a Formula

The rollout is limited to Microsoft 365 Insider Beta users holding a Copilot license.

Image
Image
Image

Overview

  • Users can type =COPILOT(...) to run natural-language prompts that reference ranges, nest inside other formulas, and spill multi-cell results that recalculate when data changes.
  • Rollout has begun for Windows Version 2509 (Build 19212.20000 or later) and Mac Version 16.101 (Build 25081334 or later) in the Insider Beta Channel, with Excel for the web to follow via the Frontier program.
  • Microsoft set usage limits at 100 calls per 10 minutes and 300 per hour, and it recommends passing larger arrays in one call, with plans to raise these thresholds over time.
  • Known limits include no live web or enterprise data access, possible omitted rows in large array returns, and dates output as text; Microsoft advises reviewing outputs for accuracy.
  • Microsoft says data sent through COPILOT is not used to train models and is only used to generate results, and The Register reports Microsoft 365 Copilot costs $30 per user per month.