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!
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)
Excel image not showing up on Windows users
I use Excel on Mac, and I've prepared a quotation list with all of the product images inserted into cells. When I send the Excel document to another Mac user, they are able to see the images. However, when I send it to a Microsoft user, they don't see any images in the document. I've attempted to upload it to Google Drive, but I encountered the error message below: Does anyone know a solution to this?
Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel TeamCharting help needed
Dear Experts, I have a data as below, So , in Column "G" we have 2 Rntis( 21,8,66 & 53714), and I need to plot the time difference for report of each rnti, which is calculated by subtracting the consecutive - SFNs, for that rnti. Now , the problem here is that in below for example , for the rnti-53714, it's not correct, for example at row-244, my last report for rnti=53714 came at row 241, so the difference should be (821-789) * 10, while in my case it's doing the subtraction in consecutive SFNs, which basically messes up my analysis. I tried to do something like below from column W to AF, but not sure how to achieve this properly( X axis should be my time, Y axis should be my average-ms and distribution should be based on the RNTI. Attached is the worksheet..(anything in -ve and above 400 is Outliers and need to be removed) in ms column also. Thanks in Advance! Br, Anupam
PLEASE HELP - Excel Horizontal Scroll Not Working
Hello all: I have an excel workbook that is many columns wide. I am on a Macbook Pro, Office 365. Scroll lock is *not* on, please do not suggest I turn it off. I can scroll in other workbooks. On this workbook, if I am selecting cells and trying to scroll horizontally, it won't continue the horizontal scroll beyond what is visual on screen. I am extremely annoyed, please help. Thank-you, Carl
Data Model error
I am getting the following error in Excel. "We couldn't get data from the Data Model. Here's the error message we got: An unexpected error occurred (file 'pcminorobjcoll.inl' , line 109, function 'PCMinorObjectCollection<class PCProperty, class NameHashSupport> :: SetNameAndUpdateCollection'). I have found various articles that have suggested going through and checking the source data headings. I did this and nothing seems to be out of the ordinary. https://contexturesblog.com/archives/2020/03/26/excel-pivot-table-refresh-error-with-data-model/ Is there anyone that can help me? The document is fairly large and used frequently by staff. I'd like to avoid recreating it, or tearing it apart. If possible.
Macros blocked in shared OneDrive Excel workbook as untrusted source
I have a macro-enabled Excel workbook (.xlsm) stored in OneDrive and shared with another user. When they open the shared workbook in Excel Desktop, they receive the error: "Microsoft has blocked macros from running because the source of this file is untrusted." We've already tried enabling macros in Trust Center, adding Trusted Locations, and opening the file from a synced OneDrive folder rather than Excel Online, but the error persists. Since downloading the file creates a separate copy and defeats the purpose of a shared workbook, what is the correct way to allow VBA macros to run in a shared OneDrive-hosted workbook while keeping everyone working from the same file?
