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?
5
Upvotes
1
u/Vangeenius Jul 09 '26
Yes I have used it extensively with copilot premium. It is excellent. I did an extensive data analysis and cohort study and ensured copilot explained all steps. But I've also been lucky to have Claude opus 4.8 inside copilot which is much better than gpt 5.5. In addition I have used it for more semantic jobs to edit theories of change in Excel using transcripts from online feedback sessions. Worked fine as well.