1. A

    slicer linked with not more than 3 pivot table

    HI there I want to know is it possible that slicer can be linked up with more than 3 pivot tables. i have tried with 4 tables but could not succeed. please help me in this regards.
  2. J

    Pivot slicer not custom sorting like it should

    I have a custom sort list set up in Excel. The Pivot table is accepting the sort and sorting accordingly. However, the slicer is not sorting by the custom list. It is only sorting alphabetically. Is there something else that needs to happen to get the slicer to sort properly? As a...
  3. Worf

    VBA: Finding selected slicer items without a loop

    Sometimes you have slicers with a long list of items, and need to find out what are the selected items. Normally, it is necessary to loop through all items to get this information, as shown on the first code. However, if the pivot table is created with the Data Model option checked, it will be...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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.
  16. 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
  17. 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...
  18. 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...
  19. 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...
  20. 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.

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...