Change All Pivot Charts With One Filter

Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click. In earlier versions, you can use programming to change the report filters in multiples pivot tables. AlexJ has shared a nice technique for using a single Report Filter to update multiple pivot tables. This technique … Continue reading “Change All Pivot Charts With One Filter”

Drill to Detail With Excel Slicer Filters

With Slicers in Excel 2010, you can easily filter several pivot tables with a single click. In the screen shot below, the Slicers are filtering the Severity and Priority fields in the pivot table. Unexpected Results With Drill to Detail Thanks to a tip from AlexJ, I learned that Slicers, combined with a pivot table’s … Continue reading “Drill to Detail With Excel Slicer Filters”

Short or Full Excel Drop Down List

You can make data entry easier in Excel, by create a drop down list with data validation. Sometimes those lists are so long, that they become a pain to use. Here’s a technique from AlexJ, that lets users switch between a full list of customers, and a short list of top customers. The technique is … Continue reading “Short or Full Excel Drop Down List”