slicer

  1. C

    Slicer for 12 hour period

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

    PivotTables / PivotChart, showing data for a value that could be in 1 or 2 columns

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

    VBA: Un-protect, Run, Protect (3 Specific protections)

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

    Colour Coding Slicer Selection to Match Colours on link PivotCharts

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

    Slicer changing chart styles

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

    Dont know why im getting error 1004 object error

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

    Cell Reference from Table Slicer Selection (Non-PivotTable)

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

    Pivot Table filtering question (Parameter with multiple parents)

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

    Slicer connection to different source

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

    2 Pivot Tables-Disconnect Slicer from Second Pivot Table

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

    Public Function seems to be slowing down all my subs

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

    VBA - Slicer Selection

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

    Slicer sinc VBA error

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

    Select multiple items in Slicer

    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( _...
  15. M

    Worksheet Change code

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

    How to add identical slicers to multiple sheets with identical Tables headers on each sheet

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

    Refresh Pivot Table w/VBA upon Slicer Selection Change

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

    Hide columns without values in a graph

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

    Macro to generate Pdf of all pivot table slicer items. Pivot table connected to OLAP cube.

    I've followed instructions on this thread : https://www.mrexcel.com/forum/excel-questions/982591-slicer.html, But it only works on a standalone pivot table, not one connected to an OLAP cube. Is there any way to generate Pdf files of a pivot table that's connected to an OLAP cube, based on...
  20. D

    how to hide all table data/make slicer free of filter selection

    Dear Experts, I have a large data set in a table - A:G with 13k rows and 6 slicers. I would like to setup a default view when opening the excel worksheet that would - 1) refresh all data in a table 2) hide all table data/make slicers free of any filter selection. I also use below vba as a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top