Power Query Problems

Fix Blank Conditional Column Dialog in Excel Power Query

Amos GikundaAmos Gikunda Nov 10, 2026 868 views

Question details

The Conditional Column and Invoke Custom Function dialogs open as blank windows in Excel Power Query, preventing users from making configurations.

How to Fix Blank Conditional Column or Custom Function Dialogs in Excel Power Query
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user is trying to add a conditional column or invoke a custom function within the Power Query Editor.
Observed behavior
The expected configuration dialog boxes appear completely blank, making it impossible to see options or continue working, even if Office is fully updated.
Before you start

Make sure to save your current Excel workbook to avoid losing any recent data or query progress in case you need to restart the application completely.

Solution 1Recommended

Use Keyboard Shortcuts to Close the Dialog and Restart

Quickly bypass the unresponsive blank dialog using specific keyboard shortcuts, then restart the Power Query Editor to restore functionality.

When the Power Query dialog interface crashes or fails to render, the window is still active but invisible. You can use standard Windows keyboard shortcuts to dismiss the broken window without force-quitting the entire Excel application.

1
Focus on the blank dialog

Click anywhere inside the blank window to ensure that it has the active focus.

2
Close the blank window

Press the 'Esc' key on your keyboard. If the window does not close, press 'Alt + F4' instead. Depending on your system state, only one of these shortcuts may work.

3
Restart Power Query Editor

Once the blank window is dismissed, close the Power Query Editor entirely and then reopen it to see if the interface loads correctly.

4
Restart Excel

If reopening the editor doesn't fix the rendering, save your file, close Microsoft Excel completely, and relaunch the application.

Keyboard Shortcut Priority: Try 'Esc' first as it acts as a standard 'Cancel' command within Power Query dialogs. If that fails, 'Alt + F4' forces the active window to close.
Free Microsoft Office alternative

Experience Stable Data Processing with WPS Office

If Microsoft Excel continues to experience frustrating UI glitches like blank Power Query dialogs, consider trying WPS Office. It provides a lightweight, highly stable environment for all your spreadsheet needs without the heavy resource usage.

Seamlessly compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Free and lightweight architecture minimizes the risk of UI rendering glitches and crashes.Familiar spreadsheet interface ensures a zero learning curve for Excel users.Stable data processing features tailored for efficient and uninterrupted workflow.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Power Query dialogs suddenly go blank in Excel?

This is a known rendering bug in Microsoft Excel that can be triggered by display driver conflicts, limited system resources, or certain Windows updates disrupting the Office UI engine.

Will I lose my unsaved query steps if the dialog freezes?

If you are forced to shut down Excel via Task Manager, unapplied query steps may be lost. Using the Esc or Alt+F4 keys allows you to close just the broken dialog, safely preserving your unsaved work in the editor.

Does disabling hardware graphics acceleration fix the blank dialog issue?

Sometimes. Disabling hardware acceleration in Excel (via File > Options > Advanced > Display) can occasionally resolve UI rendering issues, though newer versions of Office have removed this manual toggle, making updating the software the preferred solution.