Fix a Blank Screen or Version Error in Excel Power Query
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.

- 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.
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.
Open the Query Using the Edit Context Menu
Use this workaround if double-clicking a query produces a blank screen or freezes Excel.
In Excel, open the affected workbook and select Data > Queries & Connections.
In the Queries & Connections pane, right-click the affected query and select Edit. Check whether it opens in Power Query Editor.

Update Excel and Test the Workbook on Another Computer
Use these checks to identify an Office build defect or compatibility issue.
Collect Workbook and Build Details for Support
Use this approach if the issue persists or you cannot update Excel yourself.
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.

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.




