Home Article index Newsletter

Deze pagina in het NederlandsHome > Article index >

Pivottable Slicers


Pivottables are one of the most powerful data analysis features Excel has to offer. From version to version, Microsoft have added functionality to this feature. The number of additions and their usefulness differ from version to version of course. Amongst the additions and updates for Excel 2010 are Pivottable Slicers. In this article I'll discuss how you can put slicers to work.


  1. Why Slicers
  2. Configuring Slicers
  3. Slicers and VBA
  4. Synchronising Slicers
  5. Show Selected Items

Other sources

Microsoft Excel - Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

Microsoft Excel - Interacting with Slicers


Showing last 8 comments of 15 in total (Show All Comments):


Comment by: Jan Karel Pieterse (17-6-2013 19:55:45) deeplink to this comment

Hi Wayne,

I would try to move the calculation form the pivot table to the query.

Comment by: Wayne (17-6-2013 20:23:47) deeplink to this comment

Calculations are ratios and can't be calculated until after level is selected.

Comment by: Jan Karel Pieterse (18-6-2013 10:32:17) deeplink to this comment

Hi Wayne,

In that case I guess you are limited to what Excel delivers, which isn't very useful in this case!

Comment by: Rachit (23-10-2013 00:56:46) deeplink to this comment

Hello there,

Excel is not letting me refresh a pivot if there is a slicer is attached to it...is there a way to work around this?


Comment by: Jan Karel Pieterse (23-10-2013 15:53:16) deeplink to this comment

Hi Rachit,

Something else must be wrong here, because a slicer should not prevent a PT from refreshing at all.

Comment by: Kin (19-8-2014 23:11:37) deeplink to this comment

Just uncheck the slicer and update the pivot. Common Slicer connect to multi pivot table will encounter this error

Comment by: Isaac (5-11-2014 21:44:56) deeplink to this comment

I'm using Excel 2010 and I've created a dashboard using a pivot table and slicers. Is it possible to create a slicer that has like drop box characteristics that would enable to have 1 slicer but be able to see all of the data in that one header?

Comment by: Jan Karel Pieterse (10-11-2014 11:34:24) deeplink to this comment

Hi Isaac,

I'm afraid you cannot change the way Slicers work.

Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.