Power Query Problems

Fix Excel Web Queries from MLB.com Stuck on Loading

Algirdas JasaitisAlgirdas Jasaitis Oct 10, 2026 869 views

Question details

The user is experiencing an issue where Excel web queries fetching data from MLB.com remain stuck in a loading state without returning any data.

How to Fix Excel Web Queries from MLB.com Stuck on Loading
Product
Microsoft Excel
Device & OS
not provided
Scenario
Importing baseball statistics from MLB.com using Excel web queries.
Observed behavior
The query gets stuck with a loading indicator and fails to return any results, affecting both new and existing workbooks.
Before you start

Ensure your internet connection is stable and verify that MLB.com is currently accessible from your web browser without requiring a login or CAPTCHA check.

Solution 1Recommended

Test Online and Repair Microsoft Office

Isolating the issue by testing the web query in Excel for the Web helps determine if the problem is with the desktop application or the source website.

If no settings have been manually changed, the issue may stem from a corrupted Microsoft Office installation or an update on the MLB.com website that affects data scraping. Testing the workbook online is the quickest way to identify the root cause.

1
Test in Excel for the Web

Navigate to office.com in your browser, sign in with your Microsoft account, upload your workbook, and open it. Check if the web query successfully loads the MLB.com data.

2
Open Windows Settings

If the query works online but fails on desktop, press the Windows key, type 'Settings', and hit Enter. Navigate to 'Apps' and select 'Installed apps'.

3
Modify Microsoft Office

Scroll down to find your Microsoft Office or Microsoft 365 installation. Click the three dots (or right-click) next to it, select 'Modify', and choose 'Online Repair'. Follow the on-screen prompts to complete the repair process.

Test Online and Repair Microsoft Office
Website Changes: If the query also fails in Excel for the Web, MLB.com might have updated its website structure, table IDs, or security protocols, which can block Excel's automated data requests.
Free Microsoft Office alternative

Try WPS Office for Your Spreadsheet Tasks

If Microsoft Excel continues to struggle with complex queries or requires constant repairs, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet tool that handles your data analysis needs without the hassle.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx workbooks directly.
  3. 3. Analyze Your Data: Use the familiar interface to continue managing your baseball statistics and other datasets effortlessly.
Fully compatible with Microsoft Excel (.xlsx, .xls) formats.Lightweight installation with fast loading times.Familiar user interface for a seamless transition.Built-in tools for data analysis and visualization without complex configurations.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel web queries suddenly stop working?

Websites frequently update their HTML structure, add anti-scraping security measures, or change data table IDs. When this happens, Excel can no longer locate the specific data it is programmed to extract, causing queries to fail or get stuck.

Can I use Power Query instead of traditional Web Queries?

Yes, using the 'Get Data > From Web' feature in Power Query is much more robust and handles modern web pages better than the older legacy Web Query feature. It is recommended for scraping data from modern websites.

What should I do if a website completely blocks Excel's data requests?

If a site blocks Excel, you may need to check if the website provides a public API, or you can use a dedicated web scraping tool to export the data as a CSV file, which can then be easily imported into your spreadsheet.

Does repairing Office delete my Excel files?

No, repairing Microsoft Office only scans and fixes the program's underlying installation files. It does not affect, modify, or delete your personal documents, workbooks, or data.