'%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 a White Pop-Up Issue in Excel Power Query
Question details
The user needs to resolve a blank white pop-up window that interrupts the process of splitting data by a delimiter in Power Query.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Splitting data columns by a delimiter inside the Power Query Editor.
- Observed behavior
- A blank white pop-up appears and blocks the operation. Reinstalling the Excel application did not resolve the issue.
Before proceeding, ensure that your Windows operating system and Microsoft Office suite are updated to the latest versions, as UI display glitches in Power Query are frequently patched in routine updates.
Gather Diagnostics and Consult the Microsoft Fabric Community
Use this recommended solution to escalate the specialized Power Query bug to Microsoft experts when basic reinstallation fails.
Because reinstalling Excel does not fix this specific white pop-up issue, it is likely a highly localized bug related to your environment, driver, or a specific Power Query version. The Microsoft Fabric Community is the official hub for advanced Power Query troubleshooting.
Write down your exact Excel version (e.g., Microsoft 365 Apps for enterprise, Version 2308) and your operating system details.
Take a clear screenshot of the white pop-up window right when you attempt to split the data by the delimiter.
Create a small, non-confidential sample of the dataset that reproduces the error when the split operation is applied.
Navigate to the Power Query section of the Microsoft Fabric Community online, create a new topic, and provide your screenshot, environment details, sample data, and step-by-step reproduction instructions.
Clear the Power Query Data Cache
Clearing the cache can resolve unexpected graphical glitches or stalled queries within the Power Query Editor.
Disable Hardware Graphics Acceleration
This is a common workaround for resolving white screens, black boxes, or blank pop-ups in Office applications caused by display driver conflicts.
Try WPS Office for Seamless Data Management
If you are tired of troubleshooting complex graphical glitches and unexpected pop-ups in Microsoft Excel, WPS Office provides a fast, reliable, and lightweight alternative. Enjoy a familiar interface and excellent compatibility without the heavy system overhead.
- 1. Download the software: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the lightweight, one-click installation process.
- 3. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx data files to continue your work instantly.
Frequently Asked Questions
Why does Power Query show a blank white pop-up when splitting columns?
A blank white pop-up is typically caused by a rendering glitch in the application's UI. This can stem from corrupted Power Query cache data, conflicts with your computer's display drivers, or a bug specific to a recent Microsoft Office update.
Will reinstalling Excel fix Power Query UI glitches?
Not always. As many users experience, a standard reinstallation often leaves cache files, user profiles, and registry settings intact. If the issue is rooted in system display settings or a deeper software bug, a simple reinstall will not resolve the white pop-up.
Where can I get advanced help for Excel Power Query?
For specialized Power Query issues, the best resource is the Microsoft Fabric Community. It features a dedicated Power Query section where specialized developers and Microsoft experts can analyze your specific bug, provided you share your OS, Excel version, and sample data.
