Fix Excel Web Queries from MLB.com Stuck on Loading
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.

- 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.
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.
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.
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.
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'.
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.

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. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx workbooks directly.
- 3. Analyze Your Data: Use the familiar interface to continue managing your baseball statistics and other datasets effortlessly.

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.




