Fix Excel for the Web Shows 'No Data Found' During Automated Tests
Question details
The user needs to resolve an issue where an EFP Record report in Excel for the web fails to load data during automated testing.

- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Running automated web tests on an Excel spreadsheet using Virtuoso automation software.
- Observed behavior
- The Excel report successfully displays data during manual operation but returns a 'No data found' error when executed via the Virtuoso automation tool.
Verify that your automated testing tool is using a supported authentication method and has the appropriate permissions to access Microsoft 365 web environments.
Verify Automation Authentication and Security Settings
Ensure that your Virtuoso workflow is not triggering Microsoft's web security controls or failing to pass the correct authentication tokens.
Automated tools like Virtuoso often interact with web applications differently than human users. If Excel for the web detects an unusual login pattern or lacks a persistent session token, it may block data retrieval to protect the file.
Attempting to bypass Microsoft security controls via basic screen scraping or unsupported headless browsers often results in empty datasets or 'No data found' errors.
Open your Virtuoso test execution logs and look for HTTP 401 (Unauthorized) or 403 (Forbidden) network errors occurring just before the Excel page loads.
Configure Virtuoso to use supported Microsoft 365 authentication protocols, such as OAuth 2.0 or valid session cookies, rather than relying on automated UI logins.
If your Excel data relies on an EFP Record add-in, verify in the automation settings that third-party extensions are permitted to execute during the automated browser session.

Escalate to the Appropriate Support Forum
Seek specialized help from the Microsoft 365 community if authentication and security settings are correct but the issue persists.
Try WPS Office for Seamless Data Management
If strict web automation security in Microsoft Excel is hindering your workflow, consider using WPS Office. As a powerful, offline-first alternative, WPS Office allows you to manage and analyze your spreadsheet data without the restrictive authentication barriers found in web-only environments.

Frequently Asked Questions
Why does my Excel report work manually but show no data in automation?
Manual sessions handle authentication, cookies, and add-in loading interactively. Automated scripts often lack persistent tokens or use headless browsers that trigger Microsoft's security protocols, preventing external data from loading.
What are the supported methods for automating Excel data retrieval?
The most reliable and officially supported method for programmatic access to Excel data is using the Microsoft Graph API. UI-based web automation tools may frequently break due to security updates or dynamic web elements.
How can I check if an Excel add-in is causing automation failures?
Try running the automated test on a blank workbook or a workbook that doesn't rely on the EFP Record add-in. If the basic workbook loads correctly, the issue is likely that the automated browser is blocking the specific add-in from fetching its data.
Can I use Virtuoso to automate desktop spreadsheet software?
Virtuoso is primarily designed for browser-based web automation. To automate native desktop applications, you generally need RPA (Robotic Process Automation) tools or to utilize built-in macro (VBA/JS) recording features.




