slicer

Hello, I'm trying to loop through all visible slicer items so that I can then copy the updated pivot table based on that slicer selection. The code below sort of works, it's just not looping through each item on the slicer one by one. Instead it selects them all and starts by removing one...

Hello everybody! It's nice to be back on the MrExcel forum :) I am currently managing a list that essentially looks like this (just a lot bigger): I would like to create a pivot table and a slicer for this (the real file is over 1000 cells) so it becomes much easier to look up specific...

Hi all need a help here. So i have a an excel dashboard about a team performance, i have a macro to set excel to send a "screen shot" of the performance dashboard for the agent that is selected on the slicer, but the thing is, i have around 200 agents and doing this one by one is a little by...

Hi, I have a Pivot table and a connected slicer. When I use the "search pane" in the pivot, I would like to have the slicer showing the selected item also. I find i annoying that the user have to scroll like 200 items before seeing what is selected. I have tested several solutions showing i text...

Hello and thank you for viewing my post. I have a spreadsheet that has 5 pivot tables on 1 tab and I've created the graphs and copy / paste those graphs onto the Dashboard tab. When I add the sliders; 5 in total, I connect 3 of the graphs to the slicer without issue but when I connect the 4th...

Hello all, I can't seem to find any pointers on this subject through Google. The idea is that I position the mouse cursor (hover over) a slicer. When the slicer has items that are not shown, I would like to scroll to the end of the slicer list, to be able to select these items. Now, the...

Good morning, all! I have been stuck on this issue for days and hope someone can help. I have a table on Sheet2 [Sheet2.Range("A2:O" & LastRow)] that gets copied to a table on Sheet1 [Sheet1.Range("Table1")] through a macro. The table on Sheet 1 starts on D17 and goes to the last row in...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...