Long ago, when many of the pivot table features were hidden away in obscure menu and dialog boxes, I created the PivotPower add-in. It makes it easy to do pivot table tasks, such as:
- change the summary function for all the data fields from Count to Sum,
- reset the field captions,
- protect the pivot table layout,
- and many other tasks
When you install PivotPower, it adds a a drop down list on the Add-ins tab of the Excel Ribbon, or a menu on the menu bar, in older versions of Excel.
Latest PivotPower Update
In the latest version of PivotPower, most of the commands will only affect the selected pivot table. For example, if there are two pivot tables on the worksheet, select a cell in one pivot table, before using the COUNT All Data command. The data fields in the selected pivot table will change.
If the active cell is not in a pivot table, all pivot tables on the active sheet will be affected when you run the command. In the screen shot below, a cell between the pivot tables is selected. When the SUM All Data command is selected, both pivot tables will be changed.
This version of PivotPower also has a fix. In the previous version, if you selected the AVERAGE All Data command, the Data labels changed, and stayed as “Avg” even if you selected a different summary function. That problem is corrected in this version.
Download the PivotPower Add-in
You can read more about the PivotPower features, and how to install the add-in, on the PivotPower page on the Contextures website. There are download links for the add-in file so you can install it, and try it out.
If you use the PivotPower add-in, and notice anything that should be fixed, please let me know!