Data Import & Export

Fix Excel for the Web Shows 'No Data Found' During Automated Tests

Huda QurayshiHuda Qurayshi Oct 20, 2026 869 views

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.

How to Fix Excel for the Web 'No Data Found' Error During Automated Tests
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.
Before you start

Verify that your automated testing tool is using a supported authentication method and has the appropriate permissions to access Microsoft 365 web environments.

Solution 1Recommended

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.

1
Review automated workflow logs

Open your Virtuoso test execution logs and look for HTTP 401 (Unauthorized) or 403 (Forbidden) network errors occurring just before the Excel page loads.

2
Update authentication methods

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.

3
Check add-in loading behavior

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.

Verify Automation Authentication and Security Settings
Supported Automation: For robust data extraction, consider using Microsoft Graph API instead of web UI automation, as it is officially supported for programmatic access to Excel files.
Free Microsoft Office alternative

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.

Free, lightweight, and fast desktop applicationFully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsStable offline data processing without web session timeouts or auth blocksFamiliar user interface ensuring a seamless migration process
microsoft office alternative - wps office

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.