Category Archives: Programming

Scroll Through Report Filter Items

In Excel 2010, slicers were added to Excel, and they make it easy to select one or more items in a pivot table’s Report Filter. If you have an older version of Excel, or if you don’t have room for … Continue reading

Posted in Programming | Leave a comment

Block Selection of All in Report Filter

With a pivot table’s Report Filters, you can select one or more items, and see the summarized results for those items only. For example, you might want to see the sales in one region, or on a specific date. You … Continue reading

Posted in Programming | Leave a comment

Hide Drop Down Arrows in Pivot Table Headings

When you add a field to the Row Label or Column Label area of the pivot table, its heading cell shows a drop down arrow. When you click the arrow, you’ll see Sort and Filter options, for the selected field. … Continue reading

Posted in Programming, Sort and Filter | 4 Comments

Number of Records in Pivot Table Source

When you create a pivot table, it is based on a pivot cache, with all of the records from the source data table. You can’t see the pivot cache, but with some programming, you can get information about the cache. … Continue reading

Posted in Programming | Leave a comment

Clear All Fields From a Pivot Table

Occasionally, you might want to tear down a pivot table, and start from scratch. You don’t have to delete the pivot table though – you can clear all the fields, and then start adding the ones you want. Clear Pivot … Continue reading

Posted in Programming | Leave a comment

Change Pivot Table Report Filters With VBA

With Report Filters at the top of your pivot table, you can select specific items from a field, and narrow the scope of your report. In the pivot table shown below, the order date field has been grouped, and Quarters … Continue reading

Posted in Programming | 1 Comment

Filter All Pivot Tables for Specific Fields Only

On my Contextures website, there are a few sample files that let you filter one pivot table, and automatically change all the other pivot tables. You can find them on the Sample Files page, in the Pivot Table section. For … Continue reading

Posted in Programming, Sort and Filter | 4 Comments

Check for Shared Pivot Cache

Last year, I posted Excel VBA code for removing a calculated field from a pivot table. The code works well if there is only one pivot table based on that pivot cache. However, a couple of comments mentioned that there … Continue reading

Posted in Programming | 2 Comments

Quickly Change Pivot Table Data Functions

It’s easy to change the summary function for one data field in a pivot table. For example, if a field shows the Sum of Units, you can right-click on that field, and change it to Count of Units. However, if … Continue reading

Posted in Programming | 3 Comments

Clean Up Pivot Table Show Details Sheets

When you double-click on the value cell in a pivot table, a new sheet is automatically inserted in the workbook. The new sheet contains a table, listing all the source data records that are summarized in the number that you … Continue reading

Posted in Programming | 2 Comments