Pivot Power Premium

The Pivot Power Premium add-in for Excel helps you by automating many of the features that aren't built in to an Excel pivot table, and by making some of the buried Excel pivot table features easier to access.

Latest version: 4.02, March 23, 2017

(Excel for Windows only -- Does Not Work in Excel for Macintosh)

Pivot Power Premium Add-in Overview

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

  • save and apply up to 5 groups of preferred pivot table settings
  • clear old items from pivot table drop downs
  • change all the data fields to the Sum function.
  • Remove "Sum of" in Value field headings
  • Apply number formatting based on source data formatting
  • Free upgrade to next version, if/when released
  • 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.

Pivot Power Premium Ribbon Tab:

Pivot Power Premium Ribbon Tab

Save Your Preferred Settings

With the Pivot Power Premium add-in, you can save your favourite pivot table and worksheet settings, and then apply them to any pivot table. In the Ribbon's Formatting group, click Set Prefs, and check the settings that you prefer. You can store up to 5 groups of preference settings.

Then, select a cell in any pivot table, and click the Apply Prefs button, to quickly apply your preferred settings to that pivot table, and to the active worksheet and workbook.

Note: Some settings are only available in Excel 2010 and later versions.

pivot power premium preferences

Store Pivot Table Layouts

With the Pivot Table Builder tools, you can store pivot table layouts, then use those stored settings to create new pivot tables, or update existing pivot tables..

Quickly Fix the Functions

When a pivot table is created, it might have one or more fields using the COUNT function, because of blanks or text in the source data. With Pivot Power Premium, you can quickly change all the values in a pivot table from COUNT to SUM, or other functions, instead of changing the fields one at a time.

pivot power premium formatting

Quickly Change Number Formatting

Instead of formatting the value fields individually, you can quickly apply a specific number format to all the value fields, or just the selected value fields. You can also store a custom number format, to apply to all or selected value fields.

You can also apply the number formats from the source data (for Excel tables in the same workbook).

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

You can see most of the ribbon commands in the screen shot below (in Excel 2013).

pivot power premium ribbon screen tips

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.
NOTE: Windows only -- does not work with Excel for Macintosh.

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: March 23, 2017 2:43 PM