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 add same formula easy way
Hello, I have numbers in C1 till Z1 cells. I would like to multiply these cells value with A1 value. Example: +A1*C1, +A1*B1......+A1*Z1 I know I could write one by one. But is there a simple way to add all cells to this formula? So if I change A1 cell value all the values have to change. C1-Z1 is not fixed. It have to change when A1 changing.
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
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.
Sheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.
Excel TEXTBEFORE function went away and gives #NAME? error
Hi all, I had an Excel sheet working using Office 2019 on a Windows 11 machine using the TEXTBEFORE function. Now after the latest Windows update, the function seems to have disappeared from excel? I now see #NAME? errors, and its not an option for selecting when adding a new function to a cell. The functions were also auto-replaced with a new prefix: ``` =_xlfn.TEXTBEFORE(L241, " ") ``` I'm on Excel Version 2410 Tried to add the build number, but I get an error on publishing saying "##.#.#### is not allowed in the community" Anybody else seen this or have any ideas on what's happening?
