Copilot in Excel: What It Does for a Small Business

Copilot in Excel now edits your workbook for you. Ask it to merge sheets, build a PivotTable or draft a budget model, and it makes the changes with Excel's own tools. Most Microsoft 365 business plans can use it without buying the Copilot add-on.

It's good at structure and fast at grunt work. It's not reliable enough to trust with numbers you haven't checked. And if anyone on your team used the =COPILOT() formula during the preview, those cells break the next time the workbook recalculates.

What can Copilot in Excel do now?

Copilot in Excel reads the open workbook, writes a step-by-step plan, then edits the file directly: cleaning and reshaping data, merging sheets, writing formulas, and building tables, charts and PivotTables. Editing is on by default when you open it. It only works on the workbook you have open, and it can't see your other files or email.

Microsoft's own description is plain: Copilot "updates your workbook using Excel's built-in features," and editing is "great for complex, multi-step tasks like reshaping data, merging sheets." That comes from Microsoft's support page for editing with Copilot, the feature Microsoft first launched as Agent Mode.

The single-workbook limit matters. Copilot in Excel "can't access other files, emails, or enterprise data." If the answer lives in a second workbook, paste it in first.

Who can use it on a business plan?

More people than you'd expect. Microsoft lists four ways in, and the last one covers most small businesses:

• Microsoft 365 Personal or Family with an AI credits plan
• Microsoft 365 Premium
• A commercial Microsoft 365 Copilot subscription
• A Copilot Chat-eligible Microsoft 365 or Office 365 business or enterprise subscription

So a firm on a standard Microsoft 365 business plan can usually edit with Copilot without the paid add-on. Microsoft notes availability "may vary depending on your license and" your tenant's configuration.

The add-on still buys you something: Microsoft says model switching between OpenAI and Anthropic models "requires a commercial Microsoft Copilot subscription or a Microsoft 365 Premium subscription." For what the add-on costs and which plans include what, see our Microsoft 365 Copilot pricing and licensing FAQ.

One thing owners miss: you can't switch this off on its own. Microsoft's Copilot in Excel FAQ says it "is a Microsoft Copilot Chat tool and can't be turned off independently." If Copilot Chat is on in your tenant, your staff already have it in Excel.

What happened to the COPILOT function?

It's gone. Microsoft's COPILOT function page says: "Starting September 14, 2026, the COPILOT function is no longer available in Microsoft Excel." It was a preview feature, limited to the Frontier and Microsoft 365 Insider programs.

Old workbooks keep their cached answers until they recalculate. Then the cell shows #NAME?. If someone built a sentiment column or a summary sheet on =COPILOT(), copy those cells and paste them back as values now, before a recalculation wipes them.

Where it works well

Repetitive cleanup and first drafts. These are the jobs we'd hand it on day one:

• Cleaning exports. A CRM or accounting export with merged cells, inconsistent dates and a junk header row. Copilot fixes the shape in one pass.
• Combining monthly sheets. Twelve tabs of sales data into one table with a month column.
• Summaries. A PivotTable and chart of revenue by client or job type, built from the table it just cleaned.
• A first-draft model. A budget or cash-flow layout with labeled inputs and formulas you can audit.

For one-step jobs, skip it. Microsoft itself says "Excel's Recommended Charts and Recommended PivotTables may be faster."

Where it goes wrong

Numbers. Microsoft says Copilot "can sometimes make mistakes, misinterpret information, or produce inaccurate results," and tells users to "review, edit, and verify anything Copilot creates before you rely on it." The same FAQ says to avoid using it for "decisions in sensitive areas such as finance, legal, or medical topics."

That's a direct warning about the exact workbooks most owners want help with. Treat Copilot's output like a new bookkeeper's first week: useful, and checked.

Three practical traps:

• Shared files. Edits land in the live file, and "anyone with access to the file can see those changes." Work on a copy of anything the team relies on.
• Calculation mode. Editing only runs when Calculation Options is set to Automatic. Big models set to Manual won't work until you change it.
• SharePoint check-out. If a SharePoint site requires check-out, Copilot in Excel on Windows or Mac won't work on files from that site. Excel for the web still does.

How should a small business roll it out?

Fix permissions first, then pick a few workbooks and set one checking rule. Here's the order we recommend:

1. Clean up sharing. Copilot works inside what each user can already open. If your SharePoint is overshared, fix that before anything else. Our guide to fixing SharePoint oversharing before Copilot walks through it.
2. Decide on web search. Copilot can pull from the web. Users can turn it off per session under Sources. Decide whether that's acceptable for client data.
3. Decide on Anthropic models. On commercial Copilot subscriptions, an admin has to allow Anthropic as an AI provider in the Microsoft 365 admin center before staff can pick it.
4. Start with three workbooks. Pick recurring, annoying ones: the monthly sales rollup, the timesheet export, the AR aging cleanup.
5. Set one verification rule. Every Copilot-built total gets tied back to the source system before it goes to a client, a lender or the IRS. No exceptions.
6. Know the undo. Copilot changes can be undone, and version history in OneDrive and SharePoint lets you roll back the file.

If you're still deciding whether Copilot pays for itself at all, start with whether Copilot for Microsoft 365 is worth it. Excel is usually where the answer shows up first.

Frequently asked questions

Do I need the paid Microsoft 365 Copilot license to use Copilot in Excel?

No. Microsoft lists a Copilot Chat-eligible Microsoft 365 or Office 365 business subscription as enough to edit with Copilot in Excel.

The paid license adds things like the model picker for choosing between OpenAI and Anthropic models. Availability can still vary by your tenant's configuration.

Can I turn off Copilot in Excel for my staff?

Not by itself. Microsoft says Copilot in Excel is a Copilot Chat tool and "can't be turned off independently." Your Copilot Chat admin settings control it.

If you want it off in Excel, you're making a decision about Copilot Chat across Microsoft 365.

Why do my COPILOT formulas show #NAME?

Microsoft retired the COPILOT function on September 14, 2026. Workbooks keep cached results until they recalculate, then show #NAME? because Excel no longer recognizes the function.

Copy any cells you still need and paste them as values. Use the Copilot pane for the same work going forward.

Is Copilot in Excel accurate enough for financial reports?

Not without checking. Microsoft says it can make mistakes and advises against relying on it for decisions in finance, legal or medical areas. Use it to build and clean the workbook, then tie every total back to your accounting system before anyone outside the company sees it.

What file setup does Copilot in Excel need?

An .xlsx workbook with Calculation Options set to Automatic. Microsoft also notes that if your SharePoint site requires check-out, Copilot won't edit those files in the Windows or Mac app, though Excel for the web still works. Keep files in OneDrive or SharePoint so version history is there if you need to roll back.