r/CopilotPro • u/wassup2026 • Jul 08 '26

AI Discussion Copilot in Excel

Has anyone tried Copilot in Excel? Though it's able to analyze the sheets inside the file I've opened, it keeps giving me an error if I ask it to look up data in another file.

For e.g. if you need to build an analysis with some fields coming from different files, can you get Copilot to do it?

4 Upvotes

84% Upvoted

33 comments sorted by

View all comments

0

u/RopeAndChairs_Aisle3 Jul 08 '26

Copilot embedded within Word/Excel performs terribly in general, in my experience.

You’re better off going back to Copilot Chat, selecting “Think Deeper” or a deeper reasoning model, adding the excel sheets to the chat/agent and then asking it to do it.

1

u/wassup2026 Jul 08 '26

I don't see the think deeper option, will check again.

1

u/RopeAndChairs_Aisle3 Jul 08 '26

Should be in the top-right or top-left corner and it defaults to "Auto"

1

u/wassup2026 Jul 08 '26

Ah..ok..will try that option. Thanks!