slicers

My slicers are using different tabs for sources, so they won't link in the report connection. I once created a massive slicer that would edit any slicers you attached to it without using the report connection feature. Although, for the life of me, I cannot remember how I did this. Any...

Hi, I am wanting to have 3 pivot charts that change automatically, but all showing different data. So far i have my pivot showing A = Months B = Percentage C = Sales D = SIH (stock in hand) I have a pivot chart working no problem for the first column which is percentage, i have tried...

Howdy, I am an expert in a lot of things Excel, and this is driving me nuts! I create a chart and format it the way that I want. However, when I add a slicer, it changes the chart to a built-in style. I even save the chart as a template but that doesn't work. Is there a way around this...

Hello all, I have a workbook with about 100 pivot tables (no joke) and I need to change all the slicers associated with them to 'Don't move or size with cells'. When I record a macro to change 2 slicers on 1 sheet attached to 1 pivot table I get this: ActiveSheet.Shapes.Range(Array("Entity...

Hi there, I have a spreadsheet that connects several slicers to pivot tables and their associated charts. Along with the data slicers I have a timeline connected to all of them as well. When a slicer selects one or more field options, other surrounding slicers will visually indicate which...

I am using Power Query and Power Pivot. I have a list of support tickets with dates opened and dates closed. I want a pivot table to count the number of tickets opened for a month and number of tickets closed for the month. When I create a slicer for each, it has to be two separate slicers. An...

I have a sales program I re-structure every year because the COPY FILE does not work. Copying the file for a new year returns an error saying the data it is looking for is external. I have 5 worksheets with pivot tables and slicers. Sheet 1 contains the data only in a table. For every new year I...

I am trying to create a macro (button) to format all slicers to a certain style on the active worksheet. I have multiple worksheets that are nearly identical (copied from a master sheet), but the following code only works on the original sheet. How do I change the slicer name to apply to all...

Running 2016 Pro Plus. Have a large (about 110,000) row table that has also been loaded into the Data Model (no relationships established). Creating several Pivot Tables from the Data Model. Assumed that a separate PT cache was established for each PT. Created Slicers for each PT (using the...

Hello, I'm very new to VBA so pardon me if I have a glaring mistake somewhere. I am currently trying to activate only one slicer button and deactivate all the other ones based on the slicer's caption. So, basically I would loop through the slicer Items and look for a particular phrase and...

Hi I created a pivot table. I inserted slicers for that pivot table. I highlighted all rows and right click and click copy. Then I pasted the table on the same sheet. I changed the row and column of the second pivot table and it is working. But the slicers only work for the first pivot table. So...

Is it possible to protect sheet with pivot table or slicer? Because after I protect the sheet I am unable to click the slicers and error promt on pivot tables. If possible how?

Hello, I'm using multiple filters and slicers in my pivottable with more than 200 rows. Ok, so I have filtered in my slicers. Is it possible to see only the filtered lines in my pivottable filters, so I can select individual rows based on my previously made filter? So as an example: I...

I had filters on a Excel sheet and had a macro which would copy across only the filtered data to another workbook. I recently introduced slicers to the data, however the macro now copies across all the data and not just the filtered data from the slicers. Anyone know how I an over come this?

Using Excel Pro Plus and have a large table (over 100,000 rows and 100 columns) that has been added to the Data Model. I've created several Pivot tables from the Power Pivot/Manage/Pivot Table option and had a set of 16 slicers attached to 10 Pivot Tables. They were all responding correctly to...

Hi all, I have several pivot tables based on the same cube and connected slicers cross all of them. Unfortunately the slicers act independently of each-other. I.e; I have a dimension hierarchy of 9 levels. If I filter my pivot tables using slicers on level 3, I would like to only be able to...

Hello, I'm not sure if this is possible in Excel, but I would find it very useful if it is! When using multiple slicers, often you'll end up with greyed out slicer buttons where data isnt available for the current filtered data. Is there a way to prevent these 'greyed out' options from even...

Hi all, I've got a dataset which has been put into a pivot with various slicers linked. I'm looking to create an output table to show certain columns from this dataset, but only those which remain after the slicers have filtered out data. I this possible? Cheers!

I have a series of Columns containing employee names from my company directory. Column A is the Requestor of the respective row's project (several more columns containing project info). Columns B-D contain the next three managers in the org chart. <tbody> Requestor Manager Manager's Manager...

Hi, I would like to change the formatting of the font in my slicers. How do you do it?