'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Power Query Filter Dialog Empty and Excel Unresponsive
Question details
The user is encountering an issue where the Power Query filter dialog appears empty, cannot be closed, and causes the entire Excel application to become unresponsive.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to filter data sets within the Power Query Editor in Excel.
- Observed behavior
- The filter dialog fails to load any data, shows up empty, and freezes the screen, forcing the user to close Excel abnormally and risk losing unsaved workbook changes.
Before forcefully closing the application, check if your file is actively syncing to OneDrive or if AutoRecover was previously enabled to minimize potential data loss upon restart.
Force Close Excel and Recover Unsaved Work
When the Power Query dialog bug renders Excel completely unresponsive, your only immediate option is to forcefully terminate the application and recover your file upon reopening.
Because the empty dialog cannot be dismissed, the main Excel interface remains locked. Using Task Manager ensures the frozen process is completely ended so you can trigger Excel's built-in Document Recovery feature.
Press 'Ctrl + Shift + Esc' on your keyboard to open the Windows Task Manager.
Navigate to the 'Processes' tab, locate 'Microsoft Excel' in the list of running apps, right-click it, and select 'End task'.
Reopen Excel. Look for the 'Document Recovery' pane on the left side of the screen and click on the most recently auto-saved version of your file to restore your work.
Clear Power Query Data Cache and Update Office
Corrupted preview cache or an outdated software version can trigger UI bugs in Power Query. Clearing the cache and updating Excel may resolve the empty dialog issue.
Report the Bug to Microsoft Support
Because this behavior is often a product-level defect requiring deeper investigation, escalating the bug to Microsoft Support helps the product team issue a permanent patch.
Try WPS Office for Stable and Efficient Spreadsheet Management
If you frequently encounter freezing, crashing, or unresponsiveness while handling complex data tasks in Excel, consider switching to WPS Spreadsheet. It offers a lightweight, highly reliable environment for data analysis without the frustrating performance bottlenecks.
Frequently Asked Questions
Why does the Power Query filter dialog show up completely empty?
This usually occurs due to a UI rendering bug, a corrupted data preview cache, or insufficient system memory causing Excel to stall before it can retrieve and display the filter items.
How can I prevent losing my work if Excel freezes unexpectedly?
Ensure AutoSave is turned on if you use OneDrive or SharePoint. For local files, go to File > Options > Save, and reduce the 'Save AutoRecover information every' interval to 5 minutes or less.
Does clearing the Power Query cache delete my actual queries or data?
No, clearing the Data Cache only removes temporary background preview data used to speed up the Power Query Editor interface. Your actual queries, data source connections, and applied steps remain completely intact.
