AppGarden AI Readiness Scanner and Fixer logo AppGarden

AI Readiness Scanner and Fixer

Why Copilot™ may get answers wrong from a messy Excel™ sheet

By Paul Kemp · Published

You ask Copilot™ for the total by region and get a tidy, confident answer. It is wrong, and nothing in the reply says it was unsure. A worksheet built for human eyes can be hard for a tool to read, and the tool may not tell you when it has guessed.

Layouts that tend to confuse a reader

None of these is wrong for a person. Together they mean a header can be mistaken for data, or a subtotal counted twice.

Check by hand

These steps apply to Excel™ in Microsoft 365.

  1. Click inside your data and press Ctrl+A. Look at what gets selected. If it stops at a blank row or column, that is a split.
  2. Scan the top rows. Anything above the real header row (a title, a date, a logo) is a banner.
  3. Search the data block for the words "Total" and "Subtotal". Each hit inside the block is a mixed-in total row.
  4. Check Formulas → Calculation Options shows Automatic.
  5. Ask whether each column holds one kind of value: all numbers, all dates, or all text.

Fix what you find on a copy first. Move totals out of the block, unmerge, delete the blanks, and keep one header row.

Let a scan do the looking

AI Readiness Scanner and Fixer reads the active worksheet and scores it, then explains each finding and why a reader of the sheet may care. The score is deliberately blunt, meant for before-and-after comparison. Scanning, scoring, every explanation, Show me and Undo are free. Applying fixes is the paid part. The scan runs inside Excel™ and the workbook is not sent anywhere.

See the scanner for Excel™

Microsoft, Excel, Copilot and Microsoft 365 are trademarks of the Microsoft group of companies. AI Readiness Scanner and Fixer is not affiliated with or endorsed by Microsoft.