Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required
Newsletter Archive

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Articles > Pivottable Slicers

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.


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 (6/17/2013 7:55:45 PM)

Hi Wayne,

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


Comment by: Wayne (6/17/2013 8:23:47 PM)

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


Comment by: Jan Karel Pieterse (6/18/2013 10:32:17 AM)

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 (10/23/2013 12:56:46 AM)

Hello there,

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



Comment by: Jan Karel Pieterse (10/23/2013 3:53:16 PM)

Hi Rachit,

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


Comment by: Kin (8/19/2014 11:11:37 PM)

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


Comment by: Isaac (11/5/2014 9:44:56 PM)

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 (11/10/2014 11:34:24 AM)

Hi Isaac,

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


Comments are temporarily disabled. We expect commenting to be re-enabled on August 1st, 2015

For simple Excel-related questions I advise this site:

For projects and other questions, please contact me using my contact form.