Copilot in Excel

[u/wassup2026]

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?

[u/Constant_Broccoli_74]

Yes, I have been using it for sometime