A colleague sent me a screenshot in June that I have thought about more than I expected to. She had uploaded a budget workbook to Copilot Chat, asked it to add a variance column to the summary sheet, and got back a perfectly good explanation of how one would go about adding a variance column to a summary sheet. Formula included. Cell references correct. Nothing in the file had changed, because nothing in the file was ever going to change, and the message under the screenshot was "so is it broken or am I doing it wrong".
Neither, is the honest answer. She had asked a reader to write. It did what readers do, which is describe, and she read the description as a failure because the marketing for the last two years has described one product that reads and writes, and she was holding the half that reads.
That half is not a lesser version of the product. It is a different verb. Once you see the boundary between the two, most of what looks like Copilot being inconsistent in Excel turns out to be Copilot being extremely consistent about something nobody told you.
Two verbs were sold as one product
Every capability Copilot has in Excel sorts into one of two piles, and the piles do not overlap.
The first pile is reading. Look at a workbook and tell me about it. What does this formula do. Which sheet drives this total. Summarise these fifty rows. Write me a formula that would do X, as text, in the chat, for me to copy. Every one of those leaves the file exactly as it found it. The output is words, and the words might contain a formula, but the formula lands in a chat window and not in a cell.
The second pile is writing. Add the column. Build the PivotTable. Reshape this data, merge these three sheets, put a chart on it, and do it in the file, in place, while I watch. The output is a changed workbook. Microsoft shipped this in September 2025 under the name Agent Mode, and the point of it was never that the model got smarter. The point was that it got hands: it plans a sequence of steps, carries them out with Excel's own features, checks whether the result matches what you asked, and goes round again if it does not.
The pane you had before April did both from one text box, which is exactly why the two feel like one thing. Whether what came back was a paragraph or a new sheet was decided by what you asked, not by which tool you had opened.Then the box moved, and the two verbs came apart along a seam most people did not know was there.
What reading actually is
Reading is the thing that survived. If you are on an unlicensed account, this is your Copilot in Excel, and it is worth being precise about what it can do, because it is more than the screenshot suggested.
It can take the file. Upload the workbook to the standalone Microsoft 365 Copilot app or to Copilot Chat on the web, and the model has the actual cells in front of it, not a description of them. The answers quote real values. Ask about cell F7 and it reads cell F7. I have built a whole explanation routine on that, and it holds up because the thing at the other end is grounded in your data rather than in the general idea of a spreadsheet.
It can produce a formula. Not apply one, produce one. You describe what you need, it hands back =SUMIFS(...) with your headers in it, and you paste. This is where most of the "it doesn't work" reports come from, and it is where the boundary bites hardest, because the formula arrives looking like an action and is in fact a suggestion. It has not seen the cell it will land in. It has not checked whether your column is text that looks like numbers. It is a plausible answer to a question about a file, which is what reading produces.
It can reason across a workbook it has never edited. Twenty tabs, no idea what any of them do, and one prompt gets you an inventory that would have taken an afternoon by hand. Reading at scale is undersold, mostly because it does not demo well. Nothing moves on screen.
What reading cannot do is touch the file. That includes the small touches, the ones that feel like they should be free: rename the header, fill down the formula, sort by the third column. Each of those is a write, and reading does not write, no matter how small the write is.
What writing actually is
Writing is the thing Microsoft has been selling, and since June 2026 its own documentation has stopped calling it Agent Mode. The support page now says editing with Copilot was previously marketed as Agent Mode, and that as the agentic capabilities become integrated into everyday workflows they are simplifying the language and focusing on the experience rather than a separate mode. Which is a very calm way of saying the mode is now the default, for the people who have it.
Here is what it does when you have it. You open a workbook, the pane opens with Allow editing switched on, and you describe an outcome. Copilot writes a plan, shows you the reasoning as it goes, and then edits the workbook directly, using tables, formulas, charts and PivotTables rather than pasting values, so what it builds stays editable. It looks at what it made, decides whether that matches your request, and revises. For anything non-trivial it takes minutes, not seconds, and you can watch cells change while it works.
There are conditions on it, and they are the tell that this is a different animal from reading. It only works on the currently open workbook. It needs calculation set to Automatic. It wants the file in OneDrive or SharePoint with AutoSave on, because it is making a run of changes and needs somewhere for them to land. It cannot see other files, your inbox, or any organisational data from inside the edit, even on a paid licence, because the thing it is doing is operating a spreadsheet, and operating a spreadsheet means being inside it.
Reading works on a copy you hand over. Writing works on the live file you have open. That single difference is what everything else follows from.
The boundary is the pane, not the licence
This is the part I got wrong for a couple of months, and the part the title of this post slightly oversimplifies, so let me be exact.
The write capability does not technically require the paid Microsoft 365 Copilot add-on. Microsoft's Edit with Copilot page lists a Copilot Chat-eligible Microsoft 365 business or enterprise subscription as one of the ways in, alongside the paid tiers. So on paper an unlicensed user can write, under standard access, which means slower, capacity-dependent, and liable to be throttled at busy times.
On paper. In practice the write capability lives in exactly one place, which is the in-app pane, and the in-app pane is what April removed for unlicensed users at organisations over 2,000 seats. Microsoft's own labels make this legible once you know to look. Copilot Chat (Basic) means no add-on and no Copilot inside Word, Excel, PowerPoint or OneNote. M365 Copilot (Basic) means no add-on but standard access to Copilot inside the apps. M365 Copilot (Premium) means the add-on. Under 2,000 seats you are the middle label and you can, with patience, write. Over 2,000 seats you are the first label, the pane is gone, and with it every write. Same subscription, same model, same tenant admin, different answer, and the number that decides it is one you were never shown.
So for me, and for anyone else holding the first label, the title holds: what is left reads, and it does not write. The route that survived is the upload route, and an upload is a snapshot. You cannot edit a snapshot in place any more than you can edit a photograph of your kitchen and expect the kitchen to change. Everything the free tier can still do to an Excel file, it does to a copy, and hands you words about the copy.
If you are not sure which label you are, a five-minute audit settles it, and the wider map of what is still open after the pane disappears is where I sorted every surface into the same read-or-write buckets. Both are dated, because this has moved twice this year already.
Why misreading the boundary is expensive
A capability model is only worth having if it changes what you do, so here is what it changes.
The first cost is the one from the screenshot: asking a reader to write, and then trusting what comes back as if it had written. A formula in a chat window has not met your data. If you paste it and it returns a number, the number is plausible by construction, because the model was optimising for a formula that looks right against the headers it could see. A plausible number is the most expensive kind of wrong there is, which is why the verification pass exists. Reading gives you a draft. Only you can turn a draft into a cell.
The second cost is the opposite mistake: waiting. I have watched people sit on a workbook for a fortnight because "Copilot will build the summary sheet when we get it back", as though the write capability was in the post. It was not. If your label is Copilot Chat (Basic), no amount of waiting or re-installing produces the pane. The honest move is to do the write yourself, with the reader supplying the formulas and the explanation, and to stop treating the absence of a button as a temporary outage.
The half you kept is the half that thinks
I want to make the case, without pretending the write side is worthless, that the split lands better for most people than it sounds.
Writing is impressive to watch and hard to trust. Every change it makes is a change you now have to review, in a workbook that somebody downstream depends on, and the review takes roughly as long as understanding the change would have. The support page itself tells you to be careful with sensitive or shared files because Copilot makes direct changes, and points you at version history for when it goes wrong. That is not a warning about a bug. It is a description of what a writer is.
Reading is unimpressive to watch and, done properly, genuinely load-bearing. It explains before you decide. It inventories before you touch anything. It drafts a formula you then own, which is a very different relationship from a formula that appeared in cell F7 while you were watching the pane and are now not entirely sure which of the six steps put it there. The prompting habits that make reading work, naming the cell, saying you did not write the thing, supplying the shape of the data, are the same habits that make writing safe. You learn them on the read side, where the cost of a bad answer is a paragraph, not a changed file.
This is not an argument that you should be glad the pane went. The small in-place edits are a real loss that no upload workflow gets back. It is an argument that the thing you lost is the thing you had to supervise, and the thing you kept is the thing that helps you supervise. Whether that trade is worth paying to reverse is a licensing question, and it is the licensing question I am taking up next, because the documentation that describes the write side describes the three percent of accounts that have it.
Frequently Asked Questions
Can Copilot Chat edit my Excel file if I upload it?
No. Upload gives Copilot Chat a copy of the workbook to read and reason about, and everything it returns is text in the chat, including any formulas it suggests. It cannot change cells, add sheets, or apply formatting to the file you uploaded. If you need the change made, take the formula or the instructions it gives you and apply them yourself in Excel.
What is the difference between Copilot Chat and Agent Mode in Excel?
Copilot Chat reads: it analyses a workbook and answers questions about it without changing anything. Agent Mode, which Microsoft now calls Edit with Copilot, writes: it plans a multi-step change, carries it out inside the open workbook using tables, formulas, charts and PivotTables, checks the result, and revises. The first works on an uploaded copy. The second only works on the workbook currently open in Excel with editing allowed in the pane.
Does Edit with Copilot in Excel require a paid Microsoft 365 Copilot licence?
Not strictly. Microsoft lists a Copilot Chat-eligible business or enterprise subscription as one route in, with standard access that can be throttled at busy times. The catch is that editing only exists inside the in-app Copilot pane, and since April 2026 unlicensed users at organisations over 2,000 seats no longer have that pane in Excel. For them the practical answer is yes, a paid licence is the only way to write.
Why did Copilot give me a formula instead of adding it to my sheet?
Because you were talking to the read side. Copilot Chat, whether on the web or in the standalone app, produces formulas as text for you to copy rather than placing them in cells. That is expected behaviour, not a fault. Check the formula against your actual data before you paste it, since it was written from the headers Copilot could see rather than tested in the cell it will occupy.
Is Agent Mode in Excel gone?
No, it was renamed. Microsoft's documentation now describes the same capability as Edit with Copilot and says the mode language was dropped because agentic editing is becoming the standard way Copilot works in Excel. Editing is on by default in the pane, with a Chat only option if you want answers without changes. Whether you see it at all still depends on your Copilot label and whether your organisation kept the in-app pane in April.
How do I check whether my account can write to a workbook or only read it?
Open Excel and look for a Copilot button on the Home tab. If there is none, you have Copilot Chat (Basic) and can only read, via upload. If the pane opens, look above the prompt box for Allow editing: if it is there, you have write access under whichever tier your label indicates. Record the result with your build number, because these answers have changed twice in 2026 and will change again.
The way to think about it
Stop asking whether Copilot works in Excel and start asking which verb you are holding. Every request you will ever make is either a read or a write, and the two are different products that happened to share a text box for eighteen months.
Reading is what the model does to a copy: explain, inventory, draft, sanity-check, produce a formula as words. It survived April intact, it works from an upload, and it is the half that helps you think. Writing is what the model does to the live file: plan, act, verify, revise, with hands inside your workbook. It lives in the pane, it lives only in the pane, and whether you have the pane is a question about your organisation's headcount and your licence label, not about Copilot.
When a request fails, sort it. If you asked a reader to write, the failure is the boundary and the fix is to write it yourself with the reader's help. If you asked a writer to write and nothing happened, the failure is the pane and the fix is a licence conversation, not a support ticket. Almost nothing Copilot does in Excel is mysterious once you know which side of that line you are standing on. The product just never drew the line for you, and the line is the product.