Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

COPILOT in Excel

Copper Contributor

My Copilot for Excel keeps crashing - haven't even managed to use it once since i got the Copilot Pro 2 days back. Have updated Language and License settings... 


Any help / Advice?

Screenshot 2024-01-31 175526.png

2 Replies

It's still in preview, so expect some issues!

Try clearing the Cache and see if it helps:

Click the File tab at the top-left of the window.

Click the Open section.

In the Open menu, there will be a yellow warning sign marked Files Needing Attention.

Click Files Needing Attention to see a list of cached files.

Right-click on a file and select Discard local version to delete it.

Thanks Nicolas. My cache was clean so no files needing attention. However, I started looking into the Copilot messages and determined - Copilot can only work on data that is in a table format.
Once I added my excel file data into a table format, it has started working.
However, it bugged out in the first query.
Anyways, thanks a lot bud!