Agent Mode in Excel, Microsoft’s “agentic” Copilot experience for spreadsheets, is now rolling out to the desktop apps most people actually use every day, bringing the same AI that hit Excel for the web in December directly into Excel for Windows and, over the coming days, Excel for Mac.
Agent Mode leaves the browser and lands on desktop
Microsoft has flipped the switch on Agent Mode in Excel for desktop, extending the feature beyond its initial Excel for the web launch that you and I have been tracking since the first GA announcement last year. Agent Mode is part of Microsoft 365 Copilot, and it turns Copilot from a “nice to have” assistant into a partner that can plan, execute, and verify multi‑step work directly in your workbook. With today’s update, that experience is now generally available in Excel for Windows, with Mac clients getting the feature over the next few days.
If you read the earlier Excel for web rollout, the big story there was shifting from one‑off prompts (“summarize this table”) to long‑running, refreshable workflows that behave more like an AI teammate embedded in the grid. The desktop release takes that same promise and brings it to the environments where most finance teams, analysts, and operations folks still live: full‑fat Excel on Windows, with Mac finally joining the party rather than lagging months behind.
What’s new since the web GA
Microsoft didn’t just port the web experience to desktop; Agent Mode has quietly evolved during public preview based on real‑world usage. In the latest release, you get three standout improvements: expanded availability, integrated web search, and a new multi‑model reasoning system that lets you pick between OpenAI and Anthropic models for each task.
-
Expanded availability: Agent Mode now runs across Excel for the web, Excel for Windows, and Excel for Mac, so you can use the same AI workflows regardless of where you open your workbook. It’s built directly into Copilot in Excel, so you don’t have to install any separate add‑ins or extensions.
-
Integrated web search: When your scenario needs external data—think “pull in the latest FX rates” or “update market caps for this ticker list”—Agent Mode can ground its output on live web information and provide citations, instead of only working with the cells in your file.
-
Reliability and performance: Under the hood, Microsoft says task success, speed, and stability are improved across core Excel scenarios like new workbook creation, formula repair, and generating charts and PivotTables.
If you were early on Agent Mode in the Frontier program or during the initial preview, the feature you’re getting on desktop now is noticeably more robust and less “demo‑only.” The web release late last year hinted that desktop support would follow, and this general availability milestone delivers on that roadmap.
Model choice: OpenAI vs. Anthropic inside Excel
One of the most interesting additions with this desktop rollout is model choice. Instead of Agent Mode always using a single, opaque model, you now get a model switcher that lets you pick between the latest OpenAI models (currently GPT 5.2) and Claude Opus 4.5 from Anthropic. There’s also an Auto mode where Copilot chooses the model for you based on the task, but power users can explicitly override it when they know what they want.
The logic here matches what Microsoft and GitHub have learned from their developer tooling: different models excel at different kinds of work. In practice, that might look like this:
-
Use the OpenAI‑backed experience when you care about fast, structured problem‑solving for well‑defined tasks, like generating complex formulas, building a PivotTable layout, or cleaning up a messy flat table.
-
Switch to Claude Opus 4.5 when you’re tackling more open‑ended reasoning, explanations, or exploratory analysis, such as walking through multiple forecasting scenarios or iterating on a modeling approach with lots of natural language back‑and‑forth.
In Auto mode, Agent Mode will try to pick the right model for you, but the key is transparency and control: if you don’t like the results, you can swap models and re‑run the same prompt. For enterprises, Claude support does require that admins enable Anthropic as a Microsoft sub‑processor in the Microsoft 365 admin center before users see those options in the switcher.
How Agent Mode changes everyday Excel work
Excel has always been where budgets, forecasts, and operating plans get built, and Agent Mode is designed to sit right in the middle of that reality, not in a sanitized sample file. Microsoft explicitly calls out messy data, fuzzy goals, and multi‑step workflows that need to be refreshable and auditable as the kinds of scenarios Agent Mode is built for.
In practice, that means Agent Mode can:
-
Take an outcome‑based goal (“build me a loan calculator with a full amortization schedule”) and generate the tables, formulas, and formatting needed to deliver it.
-
Iterate on your workbook as you refine requirements, updating logic, adding charts, or reshaping PivotTables as your stakeholders change their minds.
-
Validate outcomes and help debug formula issues or inconsistent numbers, rather than just dumping a static answer once and calling it a day.
Microsoft’s own example for getting started is very on‑brand for Excel: you can ask Agent Mode to “build a loan calculator that computes monthly payments based on user inputs for loan amount, annual interest rate, and term in years, then generate a schedule showing month, payment, principal, interest, and remaining balance in a formatted table.” That’s the kind of task that would normally require a decent chunk of formula knowledge (and a few mistakes along the way); with Agent Mode, the whole pipeline is planned, executed, and left in your workbook as regular Excel logic you can inspect and change.
Because this desktop release sits on top of the web GA, it also inherits the broader Copilot story you’ve already covered on msftnewsnow.com: moving from “AI that answers questions” to “AI that collaborates over time inside your Microsoft 365 documents.” The difference is that Excel is now one of the best examples of that shift, not just a checkbox on a marketing slide.
How to try Agent Mode in Excel today
If you want to kick the tires, the entry point is the same across platforms:
-
Open Excel on the web, Windows, or Mac, and sign in with an eligible Microsoft 365 account.Open Copilot from the Home tab to bring up the Copilot chat pane.
-
From the Tools menu in Copilot, select Agent Mode to switch from standard Copilot assistance into the agentic experience.
-
Start with an outcome‑based prompt describing what you want to build or fix, not just a single formula—Microsoft’s team explicitly recommends phrasing your goal like “build,” “clean up,” or “analyze” rather than “what’s the formula for…”
On licensing, you’ll need one of the following:
-
A commercial Microsoft 365 Copilot subscription
-
A Microsoft 365 Premium subscription
-
A Microsoft 365 Personal or Family subscription with the AI credits model enabled
There are two important caveats. First, Personal and Family subscribers consume AI credits when using Agent Mode in Excel, so heavy usage may require watching your credit balance. Second, this release is not yet available to customers in the EU or UK; Microsoft lists those regions as “coming soon,” consistent with how other Copilot features have rolled out in waves due to regulatory requirements.
For organizations already experimenting with Copilot in Excel on the web, this desktop GA is the moment when pilot projects can graduate into standard workflows on Windows laptops and, imminently, on Macs. And for individual Microsoft 365 subscribers, Agent Mode finally brings a serious AI co‑author to the Excel icon that has lived on their taskbar for years.
Discover more from Microsoft News Now
Subscribe to get the latest posts sent to your email.
