Fix Excel From Web Internet Explorer Compatibility Mode Error
Question details
The user needs to import a data table from a dynamic internal website, but Excel's web query feature fails to recognize the table.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Importing data tables from an internal web page into a spreadsheet using the Data From Web feature.
- Observed behavior
- Excel displays a warning that table highlighting is disabled due to Internet Explorer Compatibility mode, failing to detect dynamically generated HTML tables.
Verify if the target website requires a login and password, as internal system authentication often blocks native spreadsheet web queries from accessing dynamic data.
Manually Copy and Paste the Web Data
When the spreadsheet software cannot detect dynamically generated tables via URL, manually copying the data is the fastest immediate workaround.
Modern websites often use JavaScript or JSP to convert raw backend data into HTML tables dynamically. Because the legacy 'From Web' tool relies on an older rendering engine, it cannot process these dynamic elements automatically.
Launch a standard web browser like Chrome or Edge, navigate to your internal system, and log in to view the data.
Scroll to the specific section containing the table. Click and drag your cursor over the rows and columns to select the data.
Right-click the highlighted area and select Copy from the context menu, or press Ctrl+C on your keyboard.
Open your workbook, right-click the starting destination cell, and choose 'Match Destination Formatting' to paste the raw text neatly into rows and columns.

Request a Direct Database Export Feature
For internal company systems where web queries consistently fail, adding a backend export option is the most reliable, long-term solution.
Use a Custom Python Script to Scrape the Data
For advanced users, a web scraping script can automate data extraction from dynamic, authenticated websites.
Try WPS Office for Seamless Spreadsheet Management
If legacy internet compatibility errors are slowing down your data processing, consider switching to WPS Office. It offers a lightweight, modern spreadsheet environment without the baggage of outdated rendering engines.
- 1. Download the software: Visit the official WPS website and download the free office suite.
- 2. Install and launch: Follow the simple installation prompts and open WPS Spreadsheet.
- 3. Open your files: Seamlessly open, edit, and save your existing data files without compatibility worries.

Frequently Asked Questions
Why does the From Web feature show an Internet Explorer Compatibility error?
This happens because the older 'From Web' query tool relies on legacy Internet Explorer components. If a website uses modern dynamic rendering technologies like JavaScript or JSP, the legacy engine cannot effectively process or recognize the HTML tables.
Can I automatically import web data from a password-protected intranet site?
Spreadsheet software generally struggles with web authentication, especially on dynamically generated intranet pages. You usually need to rely on direct database exports provided by your developers or use custom API endpoints instead of standard web page scraping.
What is the easiest way to import dynamic web tables without programming knowledge?
The simplest and most reliable workaround is to open the target web page in a modern browser like Chrome, manually highlight the data table, copy it, and paste it into your workbook using the 'Match Destination Formatting' option.




