How to Get the Best Performance from Office 365 Copilot

To get the best performance from Copilot in Microsoft 365, keep your Office apps on a current update channel, store your working files in OneDrive or SharePoint with AutoSave on, give Copilot a clear goal, audience and constraints in each prompt, and point it at the specific file you mean. Most slow or vague Copilot results trace back to one of those four things.

One point first, because it causes confusion: Copilot is part of Microsoft 365 subscriptions, still widely called Office 365. It is not included in one-time purchase versions such as Office 2024 or Office 2021. If the Copilot button is missing, that may simply be why.

What does Copilot need to work well?

Copilot needs a Microsoft 365 plan that includes it, desktop apps on a supported update channel, a signed-in account, connected experiences turned on, and files it can reach in the cloud. If any one of those is missing, Copilot either does not appear or gives thin answers, because it cannot see your content.

A common issue we see: Copilot was added to an account, but the apps still show the old licence. Go to File, Account and select Update License, then restart the app. That refresh resolves most cases where the button has not appeared.

How do you write prompts that give better Copilot results?

State the goal, the audience, the constraints, the evidence to use and the structure you want. Microsoft's own guidance frames prompt improvement around those five lenses. A prompt with all five gives Copilot enough to produce something usable the first time, so you are not left with a generic draft to rewrite.

• Goal. What the output is for. "Summarise this for a decision on whether to renew the contract."
• Audience. Who reads it. "For a finance director who has not seen the detail."
• Constraints. Length, tone and what to leave out. "Under 150 words, no jargon."
• Evidence. What to base it on. "Use only the figures in the attached workbook."
• Structure. The shape of the answer. "Three bullet points, then a one-line recommendation."

Compare "summarise this document" with "summarise this document in five bullet points for a client who missed the meeting, focusing on decisions and deadlines". The second takes ten more seconds to type and usually saves several minutes of editing. Microsoft publishes a free quick reference guide on iterating on Copilot output built around the same five lenses.

How do you make Copilot faster?

Copilot's speed depends mostly on the size of what you ask it to read and on your connection, not on your PC. Ask about one file or one section at a time, keep the apps updated, and close add-ins you do not use. Very large documents and workbooks take noticeably longer and can time out.

• Narrow the scope. Select the relevant text or range before opening Copilot, or name the section you mean.
• Update the apps. Go to File, Account, Update Options, Update Now. Performance improvements arrive through these updates.
• Trim add-ins. Under File, Options, Add-ins, disable the ones you no longer use. They slow the whole app, Copilot included.
• Pick the right response mode. Where Copilot offers a choice between a quick response and deeper reasoning, use quick for rewording and summaries and keep the deeper mode for analysis.
• Use a wired or strong Wi-Fi connection. Every request travels to Microsoft's servers and back.

How do you get better results in each app?

Each app has one habit that makes the biggest difference. In Excel, format your data as a table. In Word, reference the source file by name. In PowerPoint, start from an existing document. In Outlook, summarise the thread before replying. These give Copilot structure to work with, which is where it performs best.

• Excel. Select your data and press Ctrl + T to make it a table with clear column headers. Copilot in Excel works on tables and named ranges far more reliably than on loose cells, and the file needs to be saved to OneDrive with AutoSave on.
• Word. Type a forward slash in the prompt box to attach a specific file as the source. "Draft a proposal based on /Client brief" is far more accurate than asking from memory.
• PowerPoint. Ask for a presentation from a Word document you already have. Copilot follows its headings, so a well-structured document produces a well-structured deck.
• Outlook. Use Summarise on long threads first, then ask for a reply draft with the tone and length you want.

Copilot's interface keeps changing. Microsoft is currently rolling out a prompt box directly on the Copilot button in Word, Excel and PowerPoint, so the exact clicks may differ from what you see described elsewhere. The principles above stay the same.

Why is Copilot giving wrong or generic answers?

Usually because it lacks context. Copilot only knows what it can reach: the open file, files you reference, and content your account has permission to see. If the facts are not in those sources, it fills the gap with plausible general text. Give it the source, and tell it to say when something is not covered.

Two habits protect you here. First, add "use only the attached file, and say if the answer is not in it" when accuracy matters. Second, check every figure, date and name before you send anything. Copilot drafts quickly, but responsibility for what goes out stays with you.

What if Copilot is missing or greyed out?

Work through these in order: confirm your plan includes Copilot, select Update License under File, Account, install the latest updates, check that connected experiences are on, and make sure the file is saved to OneDrive or SharePoint and not opened in compatibility mode. A greyed-out button on a local file is the most frequent case.

1. Check File > Account for your product name and sign-in.
2. Select Update License, then restart the app.
3. Run Update Options > Update Now.
4. Turn on connected experiences under File > Options > Trust Center > Trust Center Settings > Privacy Options.
5. Save the file to OneDrive and switch AutoSave on. Convert older .doc or .xls files to the current format.

On a work account, your administrator may also control who has Copilot, so ask them if the steps above change nothing.

Do you need Copilot at all?

Not necessarily. Copilot is useful if you draft, summarise or analyse for a living and are prepared to build the habits above. If your work is mostly straightforward documents and spreadsheets, a one-time purchase of Office covers it without a subscription. We compare the two routes in Office 2024 Pro Plus vs Office 365.

If a subscription fits how you work, see the Office 365 account for 5 PC or Mac in our store, and check the product page for exactly which features the account includes, as Copilot availability varies by plan. Our complete Microsoft Office 365 guide explains the account options.

Frequently asked questions

Is Copilot included in Office 2024?

No. Copilot is available only with Microsoft 365 subscriptions. Office 2024 and Office 2021 are one-time purchases with a fixed feature set and do not include Copilot or receive it later.

Why is Copilot slow in Excel?

Large workbooks, data that is not formatted as a table, and a weak connection are the usual causes. Convert your range to a table, ask about one table at a time, keep the file in OneDrive with AutoSave on, and make sure Excel is fully updated.

Does Copilot work offline?

No. Every Copilot request is processed by Microsoft's cloud service, so it needs an internet connection. The Office apps themselves still work offline. Only the Copilot features pause until you reconnect.

Can Copilot see all your files?

It can reach only what your own account has permission to open, such as your OneDrive, shared files and your mailbox. It does not give you access to anything you could not already open yourself. On work accounts, administrators can restrict this further.

How do you improve Copilot's answers without starting again?

Reply to its draft with a specific change: shorter, more formal, add the deadline, remove the second point. Adjusting one thing at a time gets you to a usable result faster than rewriting the whole prompt from the beginning.