Power Query Problems

How to Fix Excel Power Query Opening to a Blank Screen

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to fix an issue where launching the Power Query editor results in a completely blank screen missing standard interface elements.

Product: Excel for Microsoft 365
Device & OS: not provided
Scenario: Attempting to use 'From Table/Range' or 'Blank Query' to import or manipulate data in Excel.
Observed behavior: The Power Query editor window opens entirely blank, without the formula bar, data tables, or table names. The legacy Power Query COM add-in is also missing.

Before you start

Ensure you have saved all active workbooks and close any unnecessary background applications to rule out memory or resource interference.

Solution 1Recommended

Update and Repair Microsoft 365

Outdated software or corrupted installation files can cause the Power Query editor to load improperly. Updating and running a system repair can resolve these rendering issues.

Microsoft frequently releases patches for known bugs in Microsoft 365. Since Power Query is now natively built into Excel rather than being a separate add-in, repairing the entire Office suite is the most effective way to restore missing components.

Update Office

Open Excel, go to File > Account > Update Options, and select 'Update Now'. Wait for the updates to download and install.

Run a Quick Repair

Open Windows Settings > Apps > Installed apps. Find Microsoft 365 in the list, click the three dots or 'Modify', and select 'Quick Repair'.

Restart and Test

Restart your computer, open your Excel workbook, and attempt to launch Power Query via the Data tab again.

About the COM Add-in: In modern versions of Microsoft 365, Power Query is built natively into Excel under the Data tab (Get & Transform Data). You no longer need to locate or enable the legacy Power Query COM add-in.

Solution 2

Test Excel in Safe Mode

Starting Excel in Safe Mode helps determine if a third-party add-in is conflicting with the Power Query editor's user interface.

Solution 3

Seek Community Assistance

If local troubleshooting fails, the issue might be a complex bug that requires advanced diagnostic help from Microsoft specialists.

Free Microsoft Office alternative

Try WPS Office for a Stable, Hassle-Free Spreadsheet Experience

If Excel continues to freeze or display blank screens during data operations, consider switching to WPS Office. It provides a lightweight, highly compatible environment for your data analysis needs without the heavy resource load.

1. Download the Installer: Visit the official WPS Office website and click the free download button.
2. Install WPS Office: Run the downloaded installer and follow the on-screen prompts to set up the software.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel files directly with perfect compatibility.

Highly stable spreadsheet editor without blank screen glitchesFully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight application that runs smoothly on older devicesIntuitive interface similar to Microsoft Office for a zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I find the Power Query COM add-in in Microsoft 365?

In newer versions of Microsoft 365, Power Query is integrated directly into Excel as 'Get & Transform Data' on the Data tab. The legacy COM add-in is no longer used or available for these versions.

Can insufficient memory cause Power Query to open a blank screen?

Yes, Power Query can be highly resource-intensive. If your system lacks available RAM or processing power, the editor UI may fail to render completely. Closing other background applications can help free up resources.

Does repairing Office delete my Excel files?

No, running a Quick Repair or Online Repair on Microsoft 365 only replaces and fixes the core application files. Your personal workbooks, data, and settings will remain untouched.

What should I do if Safe Mode fixes the blank screen?

If Power Query works in Safe Mode, a third-party add-in is likely causing the conflict. Go to File > Options > Add-ins, manage your COM Add-ins, and disable them one by one to identify the problematic extension.

Excel & Data Problems