Hello,

I have noticed differences of Copilot capabilities of M365 Copilot in web browser vs. in Excel itself.

For example, I want to count the number of lines in Excel file based on some parameters. When I put the prompt “Count the number of rows that have ‘VTT’ in column ‘Product’.” into Excel Copilot, it counts the correct number of rows.

When I put the same prompt, just starting with “In file /Sample_data.xlsx” into M365 Copilot in Teams or in the web browser, it returns incorrect count every time. The same happens when I upload the file directly to the Copilot window and not link it to Onedrive.

Mostly less (correct is 202 and Copilot returns 64 or so). I suspect it cannot access the entire document.

I have tried many similar simple tests with other prompts and it is often the same result – in Excel good, elsewhere bad.

Why does this happen?

Is it because the file is indexed only partially in some sort of index and web Copilot draws from that and cannot see the data itself? 

How can I allow the Teams/web Copilot to access the data so the results are correct? I don’t want to open Excel everytime to use the data inside. 

Thank you very much!!

PS: When I test the same prompts with ChatGPT 4o mini, it responds correctly every time, so the data is AI-readable.

​Hello,I have noticed differences of Copilot capabilities of M365 Copilot in web browser vs. in Excel itself. For example, I want to count the number of lines in Excel file based on some parameters. When I put the prompt “Count the number of rows that have ‘VTT’ in column ‘Product’.” into Excel Copilot, it counts the correct number of rows.When I put the same prompt, just starting with “In file /Sample_data.xlsx” into M365 Copilot in Teams or in the web browser, it returns incorrect count every time. The same happens when I upload the file directly to the Copilot window and not link it to Onedrive.Mostly less (correct is 202 and Copilot returns 64 or so). I suspect it cannot access the entire document. I have tried many similar simple tests with other prompts and it is often the same result – in Excel good, elsewhere bad. Why does this happen?Is it because the file is indexed only partially in some sort of index and web Copilot draws from that and cannot see the data itself? How can I allow the Teams/web Copilot to access the data so the results are correct? I don’t want to open Excel everytime to use the data inside. Thank you very much!!PS: When I test the same prompts with ChatGPT 4o mini, it responds correctly every time, so the data is AI-readable.  Read More

​