•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query xls problem
Our take
Hello everyone,
I'm reaching out to seek your help with a frustrating issue I'm encountering in Power Query within Excel. Whenever a pop-up window appears—such as when attempting to merge or delete queries—the window opens, but the screen turns completely white, rendering it impossible to see options or interact effectively. This has hindered my workflow significantly. Has anyone else faced this challenge? If so, I would greatly appreciate any solutions or workarounds you could share. Thank you in advance for your assistance!
Best,
/u/angelinament
Hi everyone,
I’m having an issue with Power Query in Excel. Every time a pop-up window appears (for example when I try to merge queries or delete a query), the window opens but the screen is completely white/blank, so I can’t see any options or interact properly.
Has anyone else experienced this? If so, were you able to fix it?
Thanks in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- PowerQuery hangs forever in refresh when multiple computers are used to editI'm having a sudden problem in which when I make edits on another computer and try to refresh PowerQuery on my primary computer, it refreshes forever or sometimes refreshes for hours before throwing up a random memory error. Normally, the refreshes take between 3 and 10 minutes. I've used this setup for a year now with no issues before last week. I have an relatively elaborate PowerQuery setup that pulls in shared data from many sources, including online, Dropbox, SharePoint, OneDrive, and in-workbook excel tables. Lots of merges, lots of custom formulas. All file locations are variable parameters that are changed via a dropdown in Excel. I do most of my work on an up-to-date Windows 11 version of Excel running on a Mac via Parallels. The other machine I occasionally edit on is another up-to-date version of Excel on Windows 11. They are synced via Dropbox. At first I thought my VM was corrupted, so I reinstalled fresh. It worked fine until the next time I edited on another machine. I've deleted all PowerQuery and Excel caches and it still happens. Nothing I'm doing is new, so I'm not sure why it suddenly breaks. Any thoughts? submitted by /u/WorldsGreatestWorst [link] [comments]
- Power Query Merge Issue - Duplicate Tables After Refresh?Hi everyone, I have two Excel sheets, each containing a table. I’m using Power Query to merge them into a new table (Merge query), and everything works fine initially. However, after I load the result back into Excel, I notice something odd: The merged sheet (called "Merge") is created correctly. But the original two sheets seem to get duplicated again as separate tables (like "Table1" and "Table2"). My main concern is this: I regularly update the data in the original two sheets. So my questions are: Will the merged query automatically reflect updates from the original sheets when I refresh and where to but the new data in the orginal sheets or the new table 1 and table 2? Or do I need to set up something specific to make sure the merge stays updated? Also, is it normal for Power Query to create duplicate tables when loading, or am I doing something wrong? Any clarification would really help. Thanks! submitted by /u/Resident_Quantity827 [link] [comments]