slicers

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.

Hey all, I am trying to create a custom combo pivot chart with slicers and am at a loss. When I use the slicers, the format will regress back to default. I have tried every common solution and need some serious help! Here are the things I've tried: Creating and formatting the chart without...

Hello, I have read that it is possible to be able click on a slicer and send one or multiple emails, which is cool. The question I have which I have not yet found an answer to, is it possible to be able to click on a slicer and make a call in Google Hangouts? thank you

Hi I hope someone can help me out with VBA for slicers. I have two slicers ("A" and "B") and I want both slicers to work when clicking on each of them. So when I click on a sliceritem (or multiple) in slicer "A" I want to clear the fitler on slicer "B", also working the other way around. I...

Hello, I am trying to figure out a way to synch multiple slicers that are connected to different PivotTables on different worksheets. The relationship is a bit complicated so I'll try to illustrate below: _______________________ Slicers: Slicer_Province Slicer_Site Slicer_Province1...

Hi, Can anyone tell me if it's possible to create new categories for slicers in pivot charts/tables? Essentially I want to be able to make new categories of slicers based on the data already in my table (for example, if I have data in columns 1-10, I want to make a slicer that will group the...

Hi and thanks in advance! I have a TABLE, not a Pivot Table This table is huge, so I have say 2 Slicers The First Slicers named "QAZ" shows 3 options: AA BB CC The 2nd Slicers named "Country" shows 5 options: Spain Italy UK Ireland (blank) When the Table is Clear with non filtered data...

I have a dilemma that I'm faced with. I have 30 slicers(3 each for 10 different sets of pivot tables). I need to update all of the slicers based on the user selecting from a single set of slicers(all of the slicers have the same info from different days). I have it set up to do this via...

I've been using slicers for some time, but I've never come across this issue. I imported allot of data (over 3 million rows) using the data model in Power Pivot. Each row in the data model contains a column with percentages, and I can't seem to sort it properly. This is what I get: 0% 1% 10%...

Can one change a font in slicers? Seems my tables look great but the slicer font is huge.

Situation: I am trying to print off reports for selected budget holders (selected from a Budget Holder Table), using the budget holder name to feed into a slicer which then updates various pivot tables. Objective: The objective is to populate efficiently the slicer with a single budget...

Hello! Looking to see if anyone can help me out with this or point me in the direction of the answer to my issue. I have workbook where i have made serval pivot tables from a data source. I am using Exel 2013 at this time. I am using Slicers to help fliter out the data on the tables, and did...

Hi all, I have several pivot tables and pivot charts that use slicers to dissect the data, I would like to have the chart title reflect the selections made via the slicers and read an interesting article that made use of the following formulae I'm not sure if I can show the site below but...

I have raw data for 2012 to 2017 - each in a worksheet. (named Data2017, Data2016 ……etc.) They are connected via a tab called key. I created a Pivot table from 2017 Raw data, then copied it to created pivot tables for each year by editing only the date fields.(named Final2017, Final2016 …..etc)...

Is there a way to keep the "% of column total" values static when applying filters to the Rows data? i.e. when slicing/filtering only Company ABC, it shows the "% of column total" is 100%. I would like to see the original the % Total (i.e. 6%).

Hi, I am trying to modify my code to clear the slicers from the active sheet only. I have two tabs with two different dashboards and just need the macro to clear the slicers depending which sheet I'm on. I tried adding the name of the sheet after ActiveWorkbook but no luck. any help is...

I have created a spreadsheet with 2 tabs. Tab 1 has slicers referencing a table on Tab 2 The table on Tab 2 contains embedded Pdfs and pictures for each item entry I can display the picture of the embedded pdf on Tab 1 dynamically but cannot double click and open the image. On Tab 2 I can...

Duplicated at Stack Overflow, but no response. I have a workbook with two pivot table that have the exact same slicers. I'm using a VBA script to synchronize the two slicers. I've named them the same with one as "Slicer_xxxx_Master" and the other as "Slicer_xxxx_Slave". The code below works...

Hi, I have multiple pivot tables and various slicers connected to them. I have since needed to create a new pivot table using the same source data. I then want to connect the existing slicers I am using to the new pit table. However, when I try this, the new pivot table does not appear in the...