PivotPower Add-in Update

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.

pivotpower01

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.

pivotpower02

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.

pivotpower03

PivotPower Fix

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!

___________

You may also like...

5 Responses

  1. P.J. says:

    Will the PowerPivot Add-in work with Excel 2003?
    Thanks,
    P.J.

  2. Yes, P.J., the PivotPower add-in will work with Excel 2003.

  3. P.J. says:

    Swweeeeet! Thanks much Deb.

  4. Claire says:

    Looks very user-friendly! Which commands will still affect all pivot tables?

  5. Claire, for all the commands except the following, all pivot tables on the sheet will be affected if the active cell in not in a pivot table. I’ve added details on the PivotPower page on Contextures.

    The exceptions are:
    Pivot Items > Show/Hide All Items — message “Select pivot table”
    Page Fields > Show Next Page Item — If more than 1 pivot table, message “Select pivot table”
    Select > Pivot Table — If more than 1 pivot table, UserForm to select
    Printing — first pivot table
    Information > Active Cell PivotTable — message “Select pivot table”

Leave a Reply to Debra Dalgleish Cancel reply

Your email address will not be published. Required fields are marked *