slicers

I built a Pivot Chart that uses Slicers to filter down my data. Once built, I can select the Pivot Chart, File, Print, adjust my margins, layout, etc... and I get the result I want, i.e the Pivot Chart only, no slicers, no Pivot Tables. I then Locked everything so users can only use the slicers...

My first Post. I have a database in SQL, managed by Access. Access doesn't do Pivot tables. Don't trust my users not to screw up an Excel based version of this. In addition, in Access you select Manufacturer to report and it runs a bunch of Pivot Tables and Saves them. This all works except...

Hi Mr. Excel, I have a slicer containing a list of ZIP codes (string), whose value will ultimately be used to extract values from another tab in a worksheet dashboard. How can I simply obtain the value from my selection in a slicer and have that populate a cell for further calculations...

Hi, Could anyone advise me on possible reason for the compile error below? I was looking for solution how to replace Pivot table filters by slicers, and intended to have particular values selected on these slicers. I asctually already had manually created the slicers there, so there was dual...

Hi all, I am trying to present some basic data in a more user friendly way. I have a basic set of data (4 columns and 72 rows) and I would like to add a slicer to this for selection without having to pivot the data. Is this possible? Thanks

I have a slicer that has quite a few values in it and having to loop through all of the items takes quite a while. When a user opens the workbook, it is setting the slicers to show only their data. However, this looping through all the users of each slicer is taking much longer than it needs to...

Hi All, Is it possible to control a slicer with VBA please? I need the slicer to look for specific weeks. These weeks are in CELs A1:A5 Wk1, Wk2 etc The slicers control a couple of pivot tables. I'm looking to find the weeks that are listed only. Is this possible please?

Hi, I would like some help with slicers and colour coding the bar chart that they relate to. I have created an overview of the number of hours each person works on a project and I would like to be able to pick two people from the same data set using the same slicer but have two different...

Hello, I have a dashboard made up of slicers and charts connected to several pivots table to drill up and down.. They have the same data source and the "Data" and pivot sheets are hidden. My next aim is to display the data (10 columns) based on the slicer selections at the bottom of the...

Hi Team: I have assigned a macro to a slicer object, but when I click on the slicer button, the macro executes but the slicer doesn't work. To keep it simple, the slicer only has a msgbox("Slicer clicked") My intention is to use slicers to run - and to then filter the raw data spreadsheet...

hi all, Im working on a macros involving different pivot tables and slicers. When I run the following: ActiveWorkbook.SlicerCaches.Add(ActiveSheet.PivotTables("sAPivot"), _ "KPI 1 Percentage").Slicers.Add ActiveSheet, , "KPI 1 Percentage", _ "KPI 1 Percentage", 155, 490, 145, 200...

I built a dasboard, it allows you to log on and se departmental information. When it does it links a couple of hidden slicers that only allow person to see into their department. When user logs out back to general view I want to make sure the slicers are not somehow going cause data to be...

Hi All, I am having a problem with some of my slicers. I am slicing a table (non Pivot table) and the slicer leaves data that should have been filtered out and hidden. I've tried re sizing my table, deleting and re attaching the slicers, changing to a range and then back into a slicer, Re doing...

Hi! I tried to use the sync slicers guide (https://www.mrexcel.com/news/sync-slicers-in-excel/) but it's not working for me. This is the code I have: Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim sc1 As SlicerCache Dim sc2 As SlicerCache Dim SI1 As...

Hi, I have 4 data sources and 10 pivots so I created 4 slicers. To link the 4 slicers, I wrote this VBA but it is not working. Can someone please help? Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim sc1 As SlicerCache Dim sc2 As SlicerCache Dim sc3 As...

Hi, I have created a Pivot Chart with Slicers etc. After the user selects the date ranges and filters. IS there a way to then export that view to a data table? Kinda of like in a regular pivot table you can click on the totals and then get the raw data related to that number? My users are...

I have some VBA that I recorded and attached to a button that would set up the slicers for the person that was only needing to view their data. Each person who used the common workbook just clicked their macro and the sheets were filtered using the slicers for their specific needs. At the end...

Hi, I run a report 7 days a week and have a few slicers per page. I have the slicers linked, but I need to update two of the slicers everyday to the latest date and the latest week. I have tried several slicers after looking online: Sub Filter_PivotField() Dim sSheetName As String Dim...

I have a dashboard style workbook with numerous slicers on various sheets which link to pivot tables on those sheets. For some reason I am seeing that when certain users refresh pivots the workbook which is linked to external Access tables as the source, the Report Connections for all of the...

I'm working on a dashboard and I want to create one slicer that will change all data on the page, some links to other sources not the same page, different slicers etc. Yet, the selections are the same. How is this possible? I thought there was a macro that could be linked.