pivot table slicers

  1. L

    VBA code to loop through all options within a single slicer and print individual reports for each

    I have a single pivot table slicer that contains 39 different last names. When I click on a last name it populates a dashboard with that athletes testing metrics. My goal is to create a VBA code that will loop through all 39 athletes and print individual reports for each to my default printer in...
  2. Sufiyan97

    Pivot Table Slicer Shows Dates which are not actually in the data <1/1/2024 or >=1/1/2017

    I have a data in which I don't have dates <1/1/2014 or >=1/1/2017 but slicers still shows them, how to get rid of them
    • Sufiyan97
    • Thread
    • pivot table date problem pivot table slicers slicer date issue
    • Replies: 8
    • Forum: Excel Questions
  3. M

    Clear all slicers, and timelines in a pivot table

    Hi, Is this the right VBA code to clear all slicers, and timelines in a pivot table? Sub ClearSlicersTimeline() Dim slcr As SlicerCache For Each slcr In ActiveSheet.SlicerCaches slcr.ClearAllFilters Next End Sub Also asked here VBA code to clear all Slicers and Timeline objects in the current...
  4. J

    Excel VBA Slicer - Ignoring a Value if Not Found in Array

    I have a pivot dashboard that is projecting Due/Overdue status for 3 tasks, measured in the following values: Overdue >15 Months Overdue 14-15 Months Overdue 12-14 Months Due in 1-30 days Due in 31-90 days Record Up to Date The Pilot tables are linked to 3 slicers (named - MDT, BRP, BCE)...
  5. W

    Pivot Table Slicer - How to change date format

    I have a date field in a pivot table which is sourced from a list object table all within the same workbook. The slicer date format is 11/06/15. I want to change its format to 11/06. Things I have tried so far with no effect in the slicer date format: change the format of the all dates...
  6. T

    Pivot Table Slicers

    Hi, I have a workbook with several pivot tables and created slicers to manage the data showing. I have noticed that when i now create a new pivot table in the workbook, the slicers do not allow me to connect to the new pivot table. Thinking that it may be something to do with the slicers, i...

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