Power Query Problems

Fix a Blank Screen or Version Error in Excel Power Query

Maira MehtabMaira Mehtab Nov 20, 2026 868 views

Question details

The user needs to open and troubleshoot Excel Power Query queries that show a blank screen, freeze, or report a newer-version error.

Fix a Blank Screen or Version Error in Excel Power Query
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Opening or editing Power Query queries in an Excel workbook.
Observed behavior
Excel may freeze or show a blank screen when a query is opened, or report that the query was created with a newer version.
Before you start

Check whether the problem affects one workbook or several, and note the exact error message. If possible, prepare a copy of an affected workbook with sensitive data replaced by sample values for testing.

Solution 1Recommended

Open the Query Using the Edit Context Menu

Use this workaround if double-clicking a query produces a blank screen or freezes Excel.

1
Show the queries

In Excel, open the affected workbook and select Data > Queries & Connections.

2
Edit the query

In the Queries & Connections pane, right-click the affected query and select Edit. Check whether it opens in Power Query Editor.

Open the Query Using the Edit Context Menu
A workaround, not a permanent fix: Right-clicking and selecting Edit worked for the reported case, but it may not resolve every blank screen or version error.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday workbook tasks. It does not fix Microsoft Excel Power Query errors, and Power Query functionality may not be preserved.

Open and edit common Microsoft Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for everyday workbook tasksWork with spreadsheet data in a lightweight office suiteMove routine spreadsheet work without relying on Excel
microsoft office alternative - wps office

Frequently Asked Questions

How can I open a query if double-clicking it freezes Excel?

Select Data > Queries & Connections, then right-click the query and choose Edit. This worked as a workaround in the reported case.

Does the newer-version error mean Excel was downgraded?

Not necessarily. An Office build defect or compatibility issue can also cause the message. Check the version under File > Account and test the workbook on another computer.

Where can I find my Excel version and build?

Open Excel and select File > Account. Look under Product Information for the version and build details.

What should I send support if Power Query still will not open?

Provide the exact error, Excel version and build, steps to reproduce the issue, and the query steps if available. Include a sample workbook with sensitive data replaced by sample values.