This page shows how to use the main features of the Contextures
Pivot Power Premium add-in. If you have a question that is not answered
here, send an email to
Debra Dalgleish -- ddalgleish @ contextures.com
Use the commands in this group to clear filters, change filter settings, change a cache, and list cache information
Watch this video for a quick tour of the Filters and Cache commands on the PPP tab in Excel. It shows how to:
Clears all filters (row, column and report) in the pivot table(s). A quick way to reset the reports.
Use the commands in the Filter drop down to change filter settings for pivot table(s).
Quickly reset all the report filters, in all pivot tables on the active sheet, to (All).
It doesn't matter which cell on the worksheet is currently selected -- all Report filters will be cleared.
Use this command to quickly sort
There's no built-in way to manually sort a field in the Report filter area, so this command makes the task easy for you.. Without this command, you would need to temporarily move the fields to the row area, sort them, then move back to the report filter area.
There are 3 types of field filters -- Label, Value and Manual. By default, you can only apply one type of filter at a time.
Use this command to turn the multiple filters setting on or off, for all pivot fields in a pivot table.
See the notes below, for details on what is affected by each command.
WARNING: Always make a backup copy of your file before making any changes to the pivot cache.
This command adds a new worksheet to the active workbook, with a detailed list of all pivot caches in the active workbook.
Displays a message box with the count of pivot caches in the active workbook.
Displays a form with the selected pivot table's cache ID, and a list of pivot caches in the active workbook. Select a cache from the drop down list, and the selected pivot table will change to that cache, if possible.
This is helpful if you have multiple pivot tables based on the same source data, but using different pivot caches. You can change the cache for one or more of those pivot tables, to reduce the number of caches.
NOTE: This feature is only available for pivot tables based on Excel lists, and some types of external data -- it does not work for Data Model or Power Pivot Tables (OLAP).
Use this command with extreme caution! It is a quick way to get rid of duplicate caches, and reduce the workbook size, but cannot be undone.
This feature is available for pivot tables based on Excel lists, and some types of external data.
This command creates a new pivot cache for the selected pivot table. There is no confirmation message.
This is useful in some situations, such as:
Last updated: January 15, 2019 7:03 PM