slicer

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

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

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

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

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.

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

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

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

Hi, I have a workbook with tons of pivot tables. How can I use one slicer to connect to all the pivot tables without having to tick each pivot table check-box individually? I find it hard to believe that there is not a 'select all'/'deselect all' option. Thanks in advance

Hi Everyone, I'm sort of a VBA n00b, so please bear with me. I'll even just take a nudge in the right direction. Essentially i'm trying to automate changing a slicer value based on a cell value. I'll do this by initiating macro1 as follows: Sub Macro1()...

Hello Excel Gurus! I am trying to create an interactive dashboard using Slicers, Pivot tables/charts and Index/Vlookup functions. There is a section where I am using INDEX to lookup text based on a Slicer selection (which I have linked in my INDEX formula). The text varies in length based on...

In my workbook after applying update on 3rd August 2019 ,in one particular workbook Slicer and Form controls are disable (grey out) and I could not use. I am using a workbook in MSExcel 2016 and I have saved the file in *.xlsx format. I tried to figure out every thing by checking in 'Trust...

Hello everyone, long time lurker and big fan of the site. It's helped me many times. I'm hoping you can help with a question Basically: 1) I've created a slicer for a pivot table 2) I created a "Custom List" through Options-Advanced to rearrange the order of the items inside the slicer to what...

I have a general question about how to set up a slicer used with several power pivot charts. I have two charts that share a timeline and display company totals and I have a slicer that allows for individual vendors to be selected. Everything works as intended, the only problem is that for this...

Hello all, Avid consumer of Mr Excel, first time poster. I am building a sortable data table that I want to include images into. I have pasted them into the corresponding cells and when I use a slicer to filter the table, everything works, images move accordingly BUT the images that should be...

Excel Guru's, I have a beautiful opportunity calculator that I've recently built. I contains a list of markets, for which I have a Slicer (from data pivot table). What I can't figure out is how to write a macro that automatically resets data in 11 specific cells when a new market is selected...

Hello, I created a pivot table that is being linked to a slicer. My slicer allows me to switch the data being presented by different views. However, when I switch around, my pivot charts keep changing the chart type (i.e. my intention is to have a combo chart, but it keeps switching to a bar...

Hello Friends, I know that i can excel export the web page, But I'm wondering if i can add a slicer (list) and activeX (button) excel export the web page? Work on slicer (list) and activeX (button)? my excel export the web page, But did not work -- slicer (list) and activeX (button) in...

I have 3 pivot tables using same source data. I have month wise budget and actual numbers (3 columns - Month, Budget, Actual). I have created one slicer for month and only want to show months which have actual numbers(for example Jan to June). Right now, it is showing all the months as budget...

Hello, I am wondering if anyone can please suggest a way to automatically run a macro, each time an item in a slicer is selected. Currently, I'm using a button that needs to be clicked to run the macro. The problem is the button needs to be clicked each time, after selecting the item in the...