Pivot Power Premium

Save time with the Pivot Power Premium (PPP) add-in for Excel. Quickly set up new pivot tables, and fix problems in existing pivot tables.

Latest version: 5.00, June 13, 2017

(Excel 2007 and later, for Windows only -- Does Not Work in Excel for Macintosh)

Pivot Power Premium Overview

The Pivot Power Premium (PPP) add-in saves you time and effort, when working with Excel pivot tables. For example, you can quickly:

  • save your favorite settings, and quickly fix new pivot tables
  • get rid of "Sum of" in the headings
  • change number formats all at once
  • fix numbers that show Count instead of Sum
  • clear old items from pivot table drop downs
  • Free upgrade to any new versions of PPP
  • and many more time-saving features

The Pivot Power Premium creates a Ribbon tab, and is for Excel 2007, and later versions.
NOTE: Windows only
-- does not work with Excel for Macintosh.

Save Your Settings

Don't waste time setting up every new pivot table. With the PPP add-in, save your favourite pivot table and worksheet settings, and apply them to any pivot table. Store up to 5 groups of pivot table settings.

Watch this animated screen shot, to see how quickly a new pivot table is fixed -- grab settings from one pivot table, and apply them to another -- or to all pivot tables in the workbook. A simple way to change the layout, style, number formatting, subtotals, and more.

remove sum of from headings with PPP add-in

Get Rid of "Sum Of"

Do you remove the "Sum of" and "Count of" in all the pivot table headings? Let the PPP add-in do that for you, with a single click. This animated screen shot shows how quick and easy it is.

remove sum of from headings with PPP add-in

Change Number Formatting

Are you tired of formatting the number fields one at a time? Use the PPP add-in to quickly format all the selected fields. This animated screen shot shows the simple steps.

remove sum of from headings with PPP add-in

Fast Fix for Functions

When you build a new pivot table, do some numbers show a COUNT, instead of a SUM? With the PPP add-in, that problem is easy to fix.

remove sum of from headings with PPP add-in

Many More Features

In addition to the features described above, there are many more timesaving commands in the Pivot Power Premium add-in.

  • Preferences: Save your preferred settings, and apply to any pivot table

  • Number Formatting: Click to set number format for selected fields or all data fields

  • Data Fields: Change all data fields, or selected fields, to SUM, or another summary function

  • Pivot Fields and Items: Clear old items, show/hide items with no data, repeat labels every row

  • Pivot Table: List Pivot Tables, Restrict/Allow Features, Go to source data, Print PivotTable

  • Filters and Cache: Clear filters, clear report filters, allow multiple filters, Cache List, Change Cache

  • Workbook: Hide/Show Tabs, Scrollbars, Headings, Gridlines, Page Breaks, Zero Values

User Guide and Screen Tips

The Pivot Power Premium kit includes a user guide which explains how the add-in works, and how to install it. The Ribbon also has screen tips to guide you as you work with the add-in.

pivot power premium ribbon screen tips

Pivot Power Premium Licensing

The Pivot Power Premium add-in is licensed to a single user, and 2 copies can be installed on that user's home and/or work computers.

Discounts for Multiple Items

When you purchase more than one copy of a Contextures product, or purchase multiple products, in the same order, Contextures Inc. is pleased to offer the following discounts.

These percentage discounts are applied automatically to your order.

  • For 2 items -- 10% discount
  • For 3 items -- 15% discount
  • For 4 items -- 20% discount
  • For 5 items -- 25% discount
  • For 20 items -- 35% discount
  • For 50 items -- 40% discount
  • For 100 or more items -- 50% discount

Buy the Pivot Power Premium Add-in

Click the Add to Cart button below, to purchase the Pivot Power Premium add-in.

You will go to a PayPal page, where you can pay with a credit card, or through your PayPal account.

Excel Versions:

  • This kit is for Excel 2007 or later .
  • It is for Windows versions only -- not designed for Macintosh Excel

Add to Cart

View Cart

Approximately 30 minutes after you pay for the Pivot Power Premium add-in, you will get a link to download a zipped file that contains the Pivot Power add-in and the user guide. If you have not received the link within 30 minutes, please contact me at

There are installation instructions in the User Guide.

How the Payment Process Works

  1. You will be taken to a secure PayPal payment site, where you can
    • pay by credit card (click the "Don't Have a PayPal Account?" button.
      paypal payment
    • or pay through your own PayPal account (if you have one).
  2. After you make the payment, you will be redirected to a secure download page, on the e-junkie website.
  3. You will also receive an email with a link to the download page.
  4. Your download will be available for 48 hours, or 5 downloads, whichever comes first.
  5. If you have any trouble with the download process, please contact me at

Add to Cart

Unconditional 30 Day Guarantee

After you purchase the Pivot Power Premium add-in, you may return it for any reason, within 30 days. Your purchase amount will be fully refunded.


If you have comments or suggestions, please contact

This version of the Pivot Power Premium creates a Ribbon tab, and is for Excel 2007, and later versions.

Last updated: June 13, 2017 7:35 PM