CoPilot Issues

Question

CoPilot Issues

Craig Gerdes 60

When using CoPilot in Excel, prompts are clicked with simple data that should be quickly analyzable. However, it often returns an error message indicating something went wrong and suggests closing Excel and trying again. The functionality appears to work only temporarily. What could be causing this issue?

0 comments

Answer accepted by question author

Chris Duong 8,825 Microsoft External Staff Moderator

Hi @Craig Gerdes,

Hope things are running smoothly on your end.

Following up on the support thread we've been working on. I hope the information I shared in my previous answer resolve the issue you were facing. If you are still facing the same issue or need assistance with anything else, kindly respond to this email, and I will be happy to help.

We want to make sure everything is working as expected and that your experience remains uninterrupted.

Thank you for your patience and understanding throughout the troubleshooting process.

I look forward to hearing from you soon.

0 comments

3 additional answers

Your answer

Answer 1

Craig Gerdes 60

Follow-up: Would there be something in the workbook that could be preventing it? I say that because if I copy a single sheet from an existing workbook to a new workbook and then try using copilot , it works like a charm.

Chris Duong 8,825 Reputation points Microsoft External Staff Moderator

2025-08-21T20:06:57.4533333+00:00
Hi @Craig Gerdes,

Thanks for the follow-up. Based on your description, it sounds like something in the original workbook possibly formatting, data structures, or hidden elements is interfering with Copilot’s ability to analyze the data. The fact that copying a sheet into a new workbook resolves the issue strongly suggests that the problem is workbook-specific.

In addition to the steps mentioned above, I recommend checking the following to ensure there are no conflicts between elements in the original workbook.

1/ Check for Problematic Workbook Elements

Some elements that may interfere with Copilot include:

Hidden or very large named ranges

Complex or broken formulas

External links or data connections

Pivot tables with missing source data

Macros or VBA scripts

Corrupted styles or formatting

Try this:

Open the original workbook.

Save it as a new file.

Remove unnecessary sheets, formulas, or formatting.

Then test Copilot again.

2/ Rebuild the Workbook

If copying a sheet into a new workbook consistently works, consider rebuilding the workbook gradually:

Start with a blank workbook.

Copy sheets one by one.

Test Copilot after each addition to identify which sheet or element causes the issue.

Please try the steps above and see if they work. I'd happy to assist if needed

Answer 2

Craig Gerdes 60

I am using a school account since I work for a community college. So perhaps an Education A5? It seems to work better on the web than the desktop version.

Chris Duong 8,825 Reputation points Microsoft External Staff Moderator

2025-08-21T18:15:54.19+00:00
Hi @Craig Gerdes,

Thank you very much for your response.

To begin, Copilot requires a valid Microsoft 365 license with the Copilot add-on. If your school account doesn’t have the correct license or if the service hasn’t been fully provisioned, it may cause instability.

For education users, Copilot is only available through Microsoft 365 A3 or A5 plans with the Copilot add-on, and must be part of an EES (Enrollment for Education Solutions) or CSP (Cloud Solution Provider) agreement.

1/ I recommend confirming with your IT administrator that your account has the correct Microsoft 365 license with Copilot enabled. You can refer to the available license options here: License options for Microsoft 365 Copilot | Microsoft Learn

You can also check this yourself by visiting https://admin.microsoft.com (if you have admin access), or by contacting your school’s IT support team.

2/ After checking with your IT administrator, if Copilot is enabled but the issue still persists, I recommend reviewing the following steps:

1 - Update Excel and Office

Ensure you are using the latest version of Excel.

Go to File > Account > Update Options > Update Now.

2 - Clear Cache and Restart

Try restarting Excel and your computer.

You can also clear Office cache by deleting contents in %localappdata%\Microsoft\Office\16.0\OfficeFileCache.

3 - Check Network Settings

If you're on a school network, ask your IT team to ensure that the following endpoints are not blocked:

*.copilot.microsoft.com

*.microsoft.com

*.office365.com

I hope this message finds you well and if there’s anything else I can help with, just let me know. I’m happy to help.

Wishing you a great day.

If you found any part of my response helpful, you might consider marking it as 'Accepted Answer' using the option below. Your input not only helps improve our suggestions but also assists others in the community who might have similar questions.

I appreciate your kind words. 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Chris Duong 8,825 Microsoft External Staff Moderator

Hi @Craig Gerdes,

Good day to you! Welcome to Microsoft Q&A forum.

Thanks for reaching out about the Excel Copilot error. To assist you effectively, could you please confirm the following details:

What Microsoft 365 license are you using? (e.g., E3, E5, Business Premium)
Are you signed in with a work/school account, a personal account, or both?

Once I receive this information, I’ll be able to determine whether the issue is related to licensing, account configuration, or another technical factor.

Looking forward to your response.

Craig Gerdes 60 Reputation points

2025-08-21T17:41:27.34+00:00

I am using a school account since I work for a community college. So perhaps an Education A5?

Share via

CoPilot Issues

3 additional answers

Your answer