1. R

    Unable to reconnect slicers after disconnecting and changing data sources

    Hi, I have many pivot tables & slicers on different sheets of my excel workbook. The file is constantly being updated(new/changing tables) by many people so my script has to update the data and all the data sources in all the pivot tables. The objective is to: 1. Dynamically identify the...
  2. J

    Cycling through slicer items

    Just a heads up, this is my first time asking a question on a MrExcel forum. So apologies in advance if I don't follow the etiquette. I have 3 pivot tables, each with its own data set and each has 3 slicers. The data in the pivot tables has different values and is of a different size. However...
  3. D

    Display the Slicer Selction in Excel Cells

    Hi, I have a data set and converted to table (not pivot table/chart - done via Ctrl+T). There are total 5 filters i have kept to view the details. Slicer 1 has products, Slicer 2 has city, Slicer 3 has brand and so on. If i select Product A,City A, and Brand A, i need to get cell A1 updated...
  4. krishna334

    Slicer connecting pivot and associated table

    Hi All, I have a table called "Data" in my worksheet. I have created a pivot using this table and have inserted a slicer. Now, when i select the values in the slicer, the pivot value also changes. But is it possible that the Table "Data" also gets filtered on making selections in the slicer...
  5. S

    Slicer list is to long to search

    Hi, I have a system generated list of all our receivings. I'm looking for a quick way to look up a specific invoice number. But to scroll through the list of 100's of invoice numbers takes to long. I have tried adding a second pivot table and using the trick of the pull down filter. But it...
  6. B

    Excel Formula Assistance (If Statement w/lookup and SUM)

    A few questions that I'm having some difficulty with, the 1st and 3rd questions are formula assistance. 1) Current formula (embedded in a text box): =ASVIEW!$AR$9 - I need to update this formula to SUM all values from AR9 through AR16. How would I go about updating this formula? 2) In Excel...
  7. B

    Combine Slicers in Pivot Table

    Hello, I have a fairly simple data table that I've easily turned into a Pivot table, but when going to add the only slicer I need, I'm not able to get all data into one slicer. My example is below. There are other columns such as dollars, etc, that I have not included in the example. What I...
  8. K

    Timeline slicer: 2x click total of the pivot provides too many lines

    Hi, I have set up a timeline slicer on a pivot for a tool in Office 365. The users use Office 2013 and the pivot behaves exactly the same on both versions: if we put the slicer on today's date, we have the result of all the lines of today. But we need more than that. In my version, if I double...
  9. E

    Excel PowerPivot Slicer - sort month chronologically

    Hi seniors, This is my second day of learning to use Data Query, PowerPivot and Slicers in excel 2016. I am trying to create an Excel Dashboard where the data is fetched from multiple excel files located in a particular folder path through a Query and then the connections are made and added to...
  10. S

    "Hide Items with No Data" greyed out in Slicer Settings

    Hi All, I'm using Excel for Mac, and am working on my budget. I've created a pivot chart with a slicer for my monthly categories, but would like for the categories with no values for the month selected to be removed from the slicer. I've googled a good bit, and tried unchecking "Hide Items with...
  11. R

    Change Multiple Measures Using A Slicer

    Hello, I have a matrix in Power Bi structured as shown below. I would like to use the same visual to show different measures, depending on the slicer selection. By that I mean that if "Revenue" is selected the visual will show revenue values for Actual, Budget and Prior Yr. and the same for any...
  12. Z

    macros and slicers

    hello, i would like to know if i can assign a macro to excel slicer or not and if yes how. the reason is i need to change value based on selection of slicer like from quantity to amount or percentage.
  13. A

    Slicer Settings Do Not Show Custom Sort Option

    Hello I made a pivot table add to the data model of the query Connection. There is no use custom list when sort in my slicer setting and I have encountered sorting problems. thank you for any help you might provide
  14. B

    Can I Freeze a Slicer

    I have a date slicer connected to a pivot table with over 3000 rows so I was wondering if it was possible to freeze it like I can with an excel row? I have the top row of my sheet frozen so I can see the column headers while I scroll but my slicer moves out of view when I scroll. I thought it...
  15. D

    Help - vba convert slicer to pdf file?

    Hi, I have a horse racing spreadsheet and want to convert each slicer data into a pdf file. for example i want to print the race meeting (slicer 1) and each race number (slicer 2) at that meeting into a pdf. is this possible using vba?. basically i want the pdf file to read like this race...
  16. L

    Slicer for age groups

    Hi I have a table like the one below. I inserted a table then I inserted Slicer for age. So I can use the slicer to filter. My question, can I group age into group like this 18-30 31-50 51-65 So the slicer can show only 3 groups only. I know that can be done in Pivot table but can it be done...
  17. N

    Dynamic slicer

    I wish to create a measure, so I can dynamically populate a slicer, but the slicers don't accept a measure as input, so I don't know what to do. Any help will be greatly appreciated. Thanks.
  18. N

    Dynamic Slicer from pivot table

    I have a pivot table and I wish to be able to make a slicer and in another list select the column that will populate the slicer. right now I have a test table, that I will leave in the description. I have 4 columns, and I wish to be able to select the column name in a list and that will populate...
  19. J

    Incorrect argument or assignment

    I want to change the workbook slicer style to “SlicerStyleDark5 2” when I run this but I get the message “Wrong number of arguments or invalid property assignment”. Can you help? Sub DarkBlue()Dim slc As SlicerCache Dim sl As Slicer Dim I As Long For Each slc In...
  20. C

    VBA Disconnecting Slicer, updating Pivottable source, reconnecting Slicer

    Hi guys, I'm running into a little but of a problem that I'm hoping someone here can help me with. On a daily report that I run I have 8 different PivotCharts from 8 different PivotTables, all from the same data source but displaying different parts of it. I also have one slicer and one...

Some videos you may like

This Week's Hot Topics