Capabilities of Copilot in Web Browser vs. in Excel

Hi adamhlavaty​ , 

Thanks for the test file and for the prompt. It allowed me to try to reproduce the behaviour. 

I saw you wrote this post in Oct. 2024. 

Here are my test results:

1. Copilot in Excel (on Desktop): Count of VTT was 109 ✅
2. Copilot in Excel (on Web): Count of VTT was 0 ❌
3. Copilot Chat (Web mode on Edge): Count of VTT was 109 ✅
4. Copilot Chat (Work mode on Edge): Count of VTT was 109 ✅

The test results lead me to the assumption: Copilot in Excel on Web App may be unable to access the entire data set in the Excel file.

I would expect Copilot in Excel (on Web) to say in such case:

"Sorry, I cannot give you the count 'cause of a lack of access to the data set. BUT I will give you a formula."

Here's some feedback worth sharing with Microsoft. 💪

Find attached screenshots showing the results of my tests. 

AndreThiemannMS​ frankfalvey​, This may be interesting for you too.