If you have ever asked an AI tool for a number and then wondered, quietly, whether you should actually believe it, you are not alone. That hesitation is the single biggest reason a lot of owners and operators keep AI at arm's length from the real work. The July 2026 update to Copilot in Excel goes right at that hesitation. Copilot answers now come with clickable inline citations, so you can check where a number came from before you act on it.
That is a small change on the surface and a big one in practice. It puts a habit that careful people already have, checking the source, straight into the tool.
What actually shipped
Microsoft's monthly "What's New in Excel" post for July 2026 covers a batch of Copilot updates. A few stand out for a business owner who wants practical wins this week.
Inline citations you can click
Copilot responses in Excel now include clickable source references so you can validate a Copilot-generated insight against the content behind it. Hover a citation and Copilot surfaces a glance card that summarizes the cited file or report in a side pane. Select the citation and you get a deeper view with more detail. The way I read it, the citations are there to help you verify information and build trust in Copilot-generated insights.
The point is simple. You are not asked to take the answer on faith. The source sits one hover away.
Answers grounded in your own data
Two more updates matter here, because a citation is only useful when the thing it points to is your actual business data.
Synced Copilot connectors are now generally available in Excel. That means you can bring connected organizational content into the grid, things like work items, support tickets, database rows, CRM records, and documents, then analyze it in plain language. Copilot also provides inline citations for those connector-based results, so a natural-language answer about your customers can point back to the specific record it used.
Copilot in Excel can also ground its analysis in governed Power BI data. You attach a Power BI report and ask Copilot to analyze performance, spot trends, and build summaries or calculations. Your existing row-level security is respected, so people only see what they are allowed to see.
More than one engine under the hood
Copilot in Excel now offers two frontier models. Per Microsoft, OpenAI's GPT-5.6 is optimized for knowledge work and stronger multi-step reasoning, and Anthropic's Claude Opus 5 helps with complex analysis, higher-quality modeling, and more polished workbooks. Being able to pick the engine for the job is part of a broader Microsoft direction toward multi-model choice inside Microsoft 365 Copilot.
Why "show your work" is the feature that counts
Strip away the product names and here is the real story. The tool that most professionals already have on their desk just made verification the default instead of the discipline.
That is a bigger deal than it sounds. When an AI writes you a summary or calculates a figure, the risk is not that it will look wrong. The risk is that it will look completely right and still be off, because AI sounds the same when it is confident and correct as when it is confident and mistaken. The only defense is to check the source. Inline citations mean the check takes a hover, not a hunt.
If you want a rule that travels well past Excel, it is this: make any AI tool show its work. Before you trust an answer enough to send it to a client, price a job, or put it in front of your team, ask where it came from and look. A tool that can point to its source is one you can start to rely on. A tool that cannot is one you keep on a short leash.
Where this fits in your own AI growth
At LaunchReady we describe how people grow with AI using The 7 Levels of AI Proficiency. Early on, a lot of the work is learning to prompt well and get useful output. The level that separates a casual user from someone who can put AI on real business decisions is the one built on judgment: knowing when to trust an answer, how to check it, and when to override it.
Inline citations are a gift to that level. They make it easy to build the checking habit into your daily work rather than treating it as an extra step you have to remember. You stay the person in the loop, the one who reads the source and makes the call. The tool just hands you the source faster.
A practical way to start this week
You do not need a new system to use this. If you have Copilot in Excel:
- Ask it a question about a spreadsheet you actually use, then click one of its citations and read what it points to. Notice whether the source says what the answer claims.
- If your business data lives in a connected system, try analyzing it in plain language now that connectors are generally available, and check the record behind an answer before you act on it.
The habit you are really practicing is bigger than one program. Any time an AI tool gives you something that will touch a customer or a dollar, ask it to show you the source, and look before you trust.
Related reading: Level 3: The Lieutenant (Critical Thinker).
Sources
- What's new in Excel (July 2026) - Microsoft Excel Blog
- Claude + GPT: Multi-model intelligence in Copilot - Microsoft Mechanics
Frequently Asked Questions
Do inline citations mean the AI is always right now?
No. They mean you can check faster. The citation points you to the source so you can confirm the answer matches it. The judgment still belongs to you.
Can Copilot in Excel work with my own business data, not just the open web?
Yes. Synced connectors are now generally available, so you can bring in connected content like CRM records and tickets and analyze it in the grid. Copilot can also ground analysis in governed Power BI data, and it respects existing row-level security.
Find your AI Proficiency level
The free 7 Levels assessment places you across seven stages of AI capability. Under ten minutes. Research-backed scoring.