Microsoft Copilot in Excel warns

Spreadsheets are getting a new kind of warning label. Microsoft Copilot in Excel can now build a worksheet shockingly fast — formulas, layouts, even extra sheets — but speed is the easy part. The hard part is whether the workbook still works next month, with messier data, more rows, and someone else using it. That is the point Office Watch pushed this week in a practical May 9 piece about writing better prompts for Copilot in Excel. ### What changed here? The immediate news is not a Microsoft product launch. It is a fresh round of guidance reacting to how people are actually using Copilot inside Excel now. Office Watch framed Copilot less like an oracle and more like a fast junior assistant — useful for getting a first draft of a workbook on screen, but not something you trust blindly with business logic. (office-watch.com) ### Why is Excel the tricky case? Because a spreadsheet is not just text. A workbook has structure, references, assumptions, and hidden failure modes. A demo can look finished while the logic underneath is brittle. Microsoft’s own support pages pitch Copilot in Excel as a tool that can build tables, charts, PivotTables, and formulas from natural-language instructions, which is great for speed. But that also means a vague prompt can produce a sheet that looks polished while encoding the wrong rules. (office-watch.com) ### So what is Office Watch actually telling people to do? Basically — specify the system, not just the outcome. Instead of asking for “a sales tracker,” ask for named tables, explicit columns, formulas that fill down correctly, handling for blanks or bad dates, and layouts that keep working when new rows get added. The article’s big idea is that better prompts are really lightweight design documents. You are telling Copilot what a trustworthy workbook should be, not just what it should resemble. (support.microsoft.com) ### Why mention a test suite? Because that is the smartest part. Office Watch says to have Copilot build checks into the workbook itself — sample inputs, expected outputs, and validation formulas that flag when calculations drift. That turns the spreadsheet into something closer to software with unit tests. It is a simple idea, but it changes the relationship: Copilot is not only generating formulas, it is also helping generate the evidence that those formulas behave. (office-watch.com) ### Is this just theoretical caution? Not really. Office Watch has been hammering on Excel Copilot’s accuracy limits for months. In a separate March 2026 test of Excel’s new `COPILOT` function, it found missing data, wrong facts, and inconsistent results, and argued that the function could not be trusted for factual retrieval without verification. So the newer workbook-prompt advice is not generic AI hand-wringing — it follows from hands-on cases where Excel’s AI features were confidently wrong. (office-watch.com) ### How does agent mode fit in? It raises the stakes. Office Watch noted on May 9 that Copilot Agent Mode is now the default experience in Word, Excel, and PowerPoint, and in Excel that means the assistant can directly edit a workbook by adding formulas, tables, or whole sheets. That is powerful, but it also makes workbook design more important. The more the AI can touch, the more you need clear constraints, schemas, and checks. (office-watch.com) ### What is the real lesson? AI is making spreadsheet creation cheaper, not making spreadsheet engineering optional. The old Excel disciplines still matter — clean tables, explicit assumptions, auditability, reusable structure, and validation. Turns out Copilot does not remove the need for those habits. It punishes the lack of them faster. (office-watch.com) ### Bottom line? The story is not that Copilot in Excel is bad at spreadsheets. It is that Copilot is good enough to tempt people into skipping the boring design work. And that boring work is exactly what makes a workbook safe to reuse. If you treat AI as a fast builder and keep humans in charge of structure and verification, Excel gets more powerful. If you treat the first draft as truth, you are just automating fragility. (office-watch.com)