slicer

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

Hi Is it possible to make slicer for 12 hour period from 6am to 6pm and 6pm to 6am? If so how would I do this Any help would be greatly appreciated Thank you Craig

Good morning, I am working on preparing a scorecard for our team, and what I want to create is a dashboard where we can select a user via a drop down, and it will update the scorecard for that user. There are 3 data points that we are looking at for performance: 1) Cycle time 2) External...

Hi there, I have a couple of macro's that need to unlocked specified sheet protections, run the code, then reinstate the protections as they were before. At the moment I can only reinstate it for the whole sheet which impacts my slicers and future use of the sheet. They are: Select...

Hi all, Wondering if this is even possible... Is it possible to set up a slicer so if when items is selected, the colour be synchronizes to the PivotCharts 'line' the Slicer is linked to? Furthermore, can this be applied to when multiple selections are made? E.g. Three people, Three names...

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

Hi All, Im trying to highlight all values in the slicer that has the word leaver in there but im getting this error 1004 application or object error The slicer name to use in formulas is called Slicer_Area1 Here is the code used with power pivot (pivot tables) Sub SelectLeavers() Dim slcr...

Hi there, I have a data-entry table, whereby a few slicers help users quickly enter their scores for various items. I am wanting to reference the selection of the 'Name' slicer (Slicer_Name1) to a cell to simply show the name/s selected in that slicer (A formula relies on this to retrieve...

Hello, I am new to Pivot Tables, so my question could be very stupid... I have a set of data which shows employees labor forecasts for the upcoming year. The data is divided as such: Employee Name; Project Code; [12 Monthly forecast columns (apr-mar)] Each Employee can be assigned to multiple...

Hi All Im trying to connect a slicer to 2 pivot tables with different sources Both data tables have been sorted and have duplicates ie Table 1 Name Week FTe A 1 7.2 A 2 7.3 B 1 7.3 B 2 7.3 Table 2 Name Month Fte A Jan 2.6 A Feb 3.2 A Mar 4.4 B Jan 2.2 B Feb 6.4 B Mar 2.2 etc I have...

Hi. I created a pivot table and introduced a slicer to filter through the table. It works great. However, I created a second chart with the same pivot table. So, when I use the slicer it changes both charts. I don't want it to do that. I only want it to the filter the first chart. I would like...

Thought it was my imagination... but... I have two public functions that I've defined which appear to be running as part of EVERY sub, regardless of if they are needed or not. [The public functions are called from my pivot table pages and are supposed to report back on which slicer items were...

I am trying to get a worksheet to only select 4 criteria from a slicer that has over 100 options in VBA. I tried the method of just recording a macro but that was too long of a command and quit. Does anybody have any code that I could adjust / alter to get me in the right direction? Thank you.

Hello, I have discovered your video about the VBA code to sinc two different slicers and was Woking fine until I have added additional item to one of my pivot tables, however the slicer remained the same, since then VBA code start giving me error Please advise

Hi, I am trying to select multiple items in a given slicer, i recorded a macro to check how it happens and the result is below Sub Macro1() ' ' Macro1 Macro ' ActiveWorkbook.SlicerCaches("Slicer_costcentername1").VisibleSlicerItemsList = _ Array( _...

I have 2 slicers running a pivot table on a sheet called "Entry Form" Slicer 1 is controlling a named cell called "CEF_Entry" Slicer 2 is controlling a named range called "CEF_Type" I would like it that when I change slicer 1 it clears Slicer 2' selection and locks my entry form requiring a...

Hi all I'm new here, and have been unable to find a solution to my specific query online or in forums, so I hope somebody can help me. The problem is with Slicers. I work in construction, pricing up potential projects. We produce a 'Report' from our software and I have manipulated this data...

To start with, I have a fair amount of experience in Excel, but very little to no experience with macros/VBA Essentially, I have an excel workbook that has a pivot table connected to a data source that has lookups/matchbacks based on a separate pivot table that's controlled by a slicer...

Hi, I have a graph like the one below: It comes from a Pivot table, and when the country is filtered with a Slicer (in this example DE), the other doesn't have values. How can I hide the column without values? Thank you