Edit with Copilot in Excel: What You Get Without Premium Copilot Licences

There is a quiet but important change in Copilot licensing: some Excel editing capability is no longer only a paid Microsoft 365 Copilot add-on story.

Microsoft’s current support page for Edit with Copilot in Excel says the feature can be used with a Copilot Chat-eligible Microsoft 365 or Office 365 business or enterprise subscription, as well as with Microsoft 365 Personal or Family with AI credits, Microsoft 365 Premium, or a commercial Microsoft 365 Copilot subscription.

That matters for businesses because many users may already have a route into useful Copilot in Excel without the premium add-on.

It does not mean every user has the same experience as a Premium Copilot user. That is the bit to get right.

What Edit with Copilot in Excel is

Edit with Copilot is the Excel experience Microsoft previously marketed as Agent Mode.

Instead of only chatting about a workbook, Copilot can work side by side with the user and make changes to the workbook. Microsoft describes it as using Excel features such as tables, charts, PivotTables and formulas, so the output remains editable inside Excel.

In the Copilot pane, users may see an Allow editing control. When editing is allowed, Copilot can apply changes to the workbook. Users can also switch to chat-only behaviour when they want explanation or advice without changing the file.

This makes it useful for multi-step spreadsheet jobs:

• Building a first version of a report.
• Reshaping data.
• Merging or reorganising sheets.
• Creating formulas.
• Adding charts or PivotTables.
• Preparing a workbook layout from a plain-English request.
• Turning a rough data set into a more useful analysis workbook.

For simple one-step Excel jobs, the old tools may still be faster. Recommended Charts, Recommended PivotTables, normal formulas and manual formatting have not become obsolete just because Copilot can act.

The licensing point businesses are missing

The useful shorthand is this:

Included Copilot Chat access can now matter inside Excel.

Microsoft’s licensing language is not just “free versus paid”. For work and school accounts, the practical labels to look for are:

• Copilot Chat (Basic): no Microsoft 365 Copilot add-on and no access to Copilot in Word, Excel, PowerPoint and OneNote.
• M365 Copilot (Basic): no Microsoft 365 Copilot add-on, but standard access to Copilot in the Microsoft 365 apps.
• M365 Copilot (Premium): the user has the Microsoft 365 Copilot add-on and priority access to the fuller experience.

Microsoft explains these labels in its Copilot licence guide. It also says Copilot Chat is included at no additional cost for many eligible Microsoft 365 and Office 365 business, enterprise, frontline, government and education subscriptions in its admin eligibility guidance.

So the right question is not simply “do we have the Premium add-on?”

The better question is:

Which Copilot label do our users actually have, and what does that label allow in Excel?

Standard access is not Premium access

This is where the difference matters.

Microsoft’s Copilot Chat comparison says users without the Microsoft 365 Copilot add-on have standard access, while users with the add-on have priority access.

Microsoft’s separate note on standard versus priority access says standard access is subject to service capacity and may vary during the day. During high demand, some capabilities may be restricted temporarily. It can also mean longer response times, limited availability of some features or temporary use of other models or functionality to complete a task.

In plain English:

• Basic users may be able to use the Excel capability.
• Premium users should get a faster and more consistent experience.
• Standard access can hit capacity limits sooner.
• Availability can vary with tenant settings, app version, Microsoft rollout and service conditions.

So it is fair to tell staff that this is included for eligible users. It is not fair to promise it will behave exactly like Premium.

Data protection still matters

For commercial users, Microsoft says Microsoft 365 Copilot and Microsoft 365 Copilot Chat are covered by enterprise data protection, with prompts and responses protected under Microsoft 365 commercial commitments and not used to train foundation models.

That is useful reassurance, but it is not a reason to skip policy. Staff still need to know which workbooks are appropriate to use, which data is too sensitive for experimentation and which outputs require review before being shared.

What Copilot Chat still cannot replace

Without the Microsoft 365 Copilot add-on, Copilot Chat does not give the same full work-grounded experience. Microsoft says work data reasoning is limited for Copilot Chat-only users and fuller reasoning across meetings, emails, chats, files and other work data requires the Microsoft 365 Copilot licence.

That difference matters in Excel.

A user may be able to ask Copilot to edit the open workbook, but that does not mean Copilot can freely reason across every relevant meeting, email, Teams chat, SharePoint file and business context. If the job depends on wider work context, Premium may still be justified.

For example, included access may be enough for:

• Reformatting a table.
• Creating formulas from visible columns.
• Building a simple tracker.
• Adding a chart to the workbook.
• Explaining a visible data set.
• Creating a first-pass report structure.

Premium is more likely to be justified when the user repeatedly needs:

• Better availability during busy periods.
• Deeper work context across Microsoft 365.
• More complex analysis across files and communications.
• Advanced agents or model choice.
• A more consistent experience for business-critical work.

Excel still needs clean workbooks

Copilot is not a magic repair layer for poor spreadsheet hygiene.

Microsoft’s Excel formatting guidance says data should be formatted as an Excel table or a supported range. Supported ranges need clean headers, no duplicate or blank headers, consistent formatting, no subtotals, no empty rows or columns and no merged cells.

Microsoft’s Excel Copilot FAQ also says Copilot in Excel works with .xlsx, .xlsb or .xlsm files saved to OneDrive or Microsoft 365 SharePoint with AutoSave turned on.

That means teams should still fix the basics:

• Save important workbooks in the right cloud location.
• Turn on AutoSave.
• Use proper Excel tables where possible.
• Give columns clear names.
• Remove merged-cell layouts from data ranges.
• Separate inputs, calculations and outputs.
• Check formulas and charts after Copilot edits.
• Keep review responsibility with the human owner.

This is especially important for finance, operations, HR and client reporting work, where a confident-looking chart can still be wrong.

The practical rollout move

Do not treat this as a reason to buy Premium for everyone.

Also do not ignore it because a user does not have the paid add-on.

A sensible route is:

1. Check user labels in Microsoft 365.
2. Identify who has M365 Copilot Basic versus Premium.
3. Test Edit with Copilot in Excel with a few real but low-risk workbooks.
4. Record where standard access is good enough and where latency or availability gets in the way.
5. Build a short set of Excel prompts and review rules.
6. Reserve Premium licences for users whose work genuinely needs priority access, broader Microsoft 365 grounding or more advanced Copilot capability.

For many teams, this changes the starting point. Excel users can begin learning how AI-assisted spreadsheet editing works before every user has a Premium licence.

That is good news for adoption. People learn by using the tool in familiar work, not by reading a licence matrix.

What to tell staff

The clearest message is:

You may already have Copilot inside Excel. If you see Allow editing, you can ask Copilot to help change the workbook. Use it for drafts, structure, formulas and analysis support. Review everything before relying on it.

Then add the caveat:

If you are on standard access, it may be slower or less consistently available than Premium. That is expected behaviour, not necessarily a fault with your tenant.

That sets the right expectation. It encourages use without overselling the feature.

Bottom line

Edit with Copilot in Excel is worth paying attention to because it changes what businesses can do before buying Premium licences for every user.

Eligible Microsoft 365 users may be able to use Copilot to edit workbooks directly through included Copilot Chat access. Premium still matters for priority, consistency and fuller Microsoft 365 grounding.

The best adoption move is to test what your users actually have, train them on the difference and build review habits before important spreadsheet work depends on it.

Sources checked

Last checked: 27 May 2026.

• Edit with Copilot in Excel
• How Copilot Chat works with and without a Microsoft 365 Copilot licence
• What Copilot licence do I have?
• Standard versus priority access in Microsoft 365 Copilot Chat
• Manage Microsoft 365 Copilot Chat
• Format data for Copilot in Excel
• Frequently asked questions about Copilot in Excel
• Enterprise data protection in Microsoft 365 Copilot and Copilot Chat