Forum Widgets
Latest Discussions
power querry
Hi everyone, I've run into a recurring issue: after refreshing a Power Query that's loaded into an Excel Table, a completely blank column sometimes appears that doesn't exist in the query output itself. In my case the table starts at cell B2, and the blank column shows up right next to my actual data. My working hypothesis is that this happens when the number of columns returned by the query decreases compared to a previous refresh: Excel's Table object doesn't always shrink to match the new result, so it keeps a "ghost" column inherited from the previous load's structure. However, This behavior seems unpredictable: when I went from 10 columns down to 5, I could only got one extra blank column, not five. Has anyone else experienced this? Is there a reliable way to force the Table to always match the query's current column count exactly, instead of refreshing on top of the old structure? And if the "ghost column" theory is right, why would only one extra column show up regardless of how many were actually dropped? Thanks in advance!
Frozen App
I am a novice in Excel and my spreadsheet and all Excel functions are frozen by the appearance of a pop-up that includes a GoTo field first and a Reference field below that . I am guessing that this box is part of creation of some formula(?) but I have no idea how to clear it. It will not cancel, delete, or "x out"; I rebooted the entire computer hoping to reset but it didn't work and it has locked up everything. Is there a way to cancel this action and save my open spreadsheet? JT26
Excel Pivot table showing only part of one row
Hello, I have an Excel pivot table that literally has one row that shows data for the 1st 3 columns and then no data for the remainder of the columns in the pivot table. All other rows in the pivot table show data for every field in the pivot table (as long as there is data in the underlying data source). The data source for the row in question is fully populated and contains no trailing spaces or other oddities that I can see. What could be causing this and how can I fix it so the data shows properly in my pivot table for this one row? (Some cell info. partially blanked out intentionally)
Pivot Table
Hi everyone, I have an issue with the pivot table. There are filters from slicers and row labels in the table; when I double-click on any category from the table to see the filtered data, Excel fetches all data, not just what I filter on. Like below, I filtered from the slicer, and from the row labels, (Bills) should be between 100,000 and 200,000. I would like to see the (Bills) for (Central) in the (Start), but it gives me 632,478 and bills less than 100,000 and 200,000, not the 3 clients. Even if I tried from (In Progress), it's the same; it brings all data. The issue is only with the Bills column, but other filters come up correctlyexcel crashes changing font color
hi all, here is a good one. in excel (via microsoft365) I can open a speadsheet and enter data into a cell. I can't change anything with the font, color etc from the ribbon or the right click menu. It works with keyboard short cuts. Excel just hangs until I am forced to crash. I have tried with an existing spreadsheet on a different PC and it works fine. I have tried with a new blank spreadsheet with entry only in one cell, same. repaired MS 365, fast and slow, uninstalled and reinstalled to no avail. I am at a loss, any clues or directions? cheers
