Software

Microsoft Adds Copilot Change Tracking to Collaborative Excel Workbooks

4 min read Editorial

Microsoft is expanding what Excel Copilot can do inside shared workbooks, adding a set of collaboration-focused tools that make it easier to track, summarize, and reverse changes when multiple people edit the same file.

According to the report from Neowin, which cites Microsoft’s update notes, the new capabilities let Copilot summarize changes across a workbook, distinguish between different edits, undo changes it made, and explain formula problems. Here’s what each one does and why it matters.

#1 Summarizes workbook changes

When several people work in the same Excel workbook, keeping track of who changed what gets messy fast. The updated Copilot can now generate a summary of the changes made to a collaborative workbook, giving you a readable overview instead of having to dig through individual edits yourself.

Advertisement

This is especially useful for shared spreadsheets that accumulate edits over days or weeks. Rather than manually hunting down modifications, you can ask Copilot for a summary and get a digest of what’s changed, which is a meaningful step up from the manual review process most teams rely on.

#2 Distinguishes edits

Beyond simply listing changes, the new feature can tell edits apart from one another. In a workbook where values, formatting, and structure can all shift at once, being able to distinguish one type of edit from another helps you understand the nature of the change rather than just its presence.

For teams reviewing a shared file, this means you can separate, say, a data entry tweak from a formula rewrite. That distinction matters when you’re auditing a workbook or trying to figure out what broke after a co-author made changes.

#3 Reverses Copilot changes

One of the more practical additions is the ability to reverse changes that Copilot itself made. When Copilot suggests edits or reworks a spreadsheet, it’s now possible to roll those specific changes back, rather than having to manually undo each step or risk reverting legitimate human edits in the process.

This gives users a cleaner safety net: if you let Copilot restructure something and don’t like the result, you can revert its work without disturbing the rest of the workbook. It also addresses a real concern with AI-assisted editing — the fear that an automated change is hard to cleanly undo.

#4 Explains formula issues

The final feature targets one of the most common pain points in Excel: confusing or broken formulas. Copilot can now explain formula issues, walking you through what a formula is doing and why it might be producing an error or unexpected result.

Instead staring at a #REF! or #VALUE! error and guessing at the cause, you can get a plain-language explanation of the problem. This is especially helpful for users who aren’t comfortable reading complex spreadsheet logic, and it turns Copilot into more of a troubleshooting companion than just a formula-writing assistant.

What this means for you

Taken together, these additions position Excel Copilot as more than a formula assistant — it’s becoming a collaboration and audit tool for shared workbooks. If you regularly work on Excel files with colleagues, these features could save real time on review and troubleshooting.

The emphasis on summarizing and distinguishing edits points to the workflow pain points that come with co-authoring, where visibility into changes is often limited. The ability to reverse Copilot’s own changes also reflects Microsoft’s ongoing effort to make AI-driven edits feel safer and more controllable, which is a reasonable response to user hesitation around trusting automated suggestions.

How to get it

These Copilot features are part of an ongoing rollout to Microsoft 365 users, so availability will depend on your subscription tier and update schedule. If you don’t see them right away, updating to the latest version of Excel and checking back over the coming weeks is the standard path.

As with many Copilot capabilities, expect incremental availability rather than an all-at-once launch across every environment. Users on the current channel should check for updates through Excel’s account or update settings, while those on the semi-annual enterprise channel may see the features arrive on a slower timeline.

Source: Neowin

Over to you: Which of these Excel Copilot features would save you the most time — the workbook change summary or the formula explanations?

Advertisement
Share:
Editorial
Written by
Editorial

Windows & Microsoft news editor at 9to5Windows. Covering everything from Windows 11 builds to enterprise updates.

Advertisement