Contextures

Pivot Table Builder Add-in

The Pivot Table Builder Add-in (PT Builder) for Excel lets you store multiple versions of the pivot table settings. Then, quickly update an existing pivot table, or create a new pivot table, based on one of the stored settings. Don't waste your time rebuilding a pivot table, if someone changes it. Just click a button to go back to your original layout.

Latest version: Pivot Table Builder 2.01, May 30, 2016

Pivot Table Builder Add-in

NOTE: The Pivot Table Builder tools are also in the Pivot Power Premium add-in. (version 4 and later)

Excel Versions:

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

Pivot Table Builder Add-in Overview

The Pivot Table Builder add-in saves you time and effort, when working with Excel pivot tables. You can store multiple versions of the pivot table field layout. Then quickly apply that layout to an existing pivot table, or build a new one. You can see a short demo in the video below.

  • Click a button to create a list of all fields
  • Use drop down lists to pick a location for the fields you want in the pivot table (Row, Column, Filter, Values).
  • For Value fields, pick the function that you want to use for each field, such as Sum or Count
  • Set the number formatting for Value fields
  • Add multiple copies of each field, if needed
  • Free upgrade to next version, if/when released
  • and many more time-saving features

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

In the video below, you can see a quick demo of the Pivot Table Builder tools.

Pivot Table Builder Ribbon Tab

Pivot Table Builder Ribbon Tab

Create New Field Setup Lists

Click a buton to create a list of all the fields in the source data. You can base the list on a pivot table, or on the source data table.

Create New Field Setup Lists

Then, adjust the settings in the list, to create the layout that you want to use. Pick a location for the field, choose a function for Value fields, and even set the number formatting.

set the number formatting

Create as many lists as you need -- one for each pivot table variation that you want to apply quickly.

Update an Existing Pivot Table

After you have one or more lists set up, you can update an existing pivot table. Change the current layout, or restore a layout that you previously used. You won't have to waste time rebuilding pivot tables that other people mess up!

Just select a cell in the pivot table, and click the Update Pivot Table button.

Update Pivot Table

In the form that appears, you'll see a drop down list of all the field list tables in the active workbook.

Select the field list table that you want to use for your settings. Then click OK, and the selected settings are applied.

selected settings are applied

Build a New Pivot Table

You can also use your field list settings to control the layout in a new pivot table. Just select a cell in the source data table, then click the Create New Pivot Table button.

Create New Pivot Table

In the form that appears, select the field list table that you want to use for your settings. Then click OK, and a new pivot table is created, with the selected settings applied.

new pivot table is created

You can also select a default layout for the new pivot tables that you create with the Pivot Table Builder -- Compact, Outline or Tabular.

select a default layout

Pivot Table Builder Demo

The Pivot Table Builder kit includes a PT Builder Demo file, with source data, pivot tables, and Field Lists. You can use it to practise using the Pivot Table Builder add-in on your own files.

Quick Start Guide and Screen Tips

The Pivot Table Builder kit includes a quick start 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.

screen tips

Pivot Table Builder Add-in Licensing

The Pivot Table Builder add-in is licensed to a single user, and copies can be installed on that user's home and/or work computers. It may not be distributed to other users.

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 Table Builder Add-in

Click the Add to Cart button below, to purchase the Pivot Table Builder 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 add-in 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 Table Builder add-in, you will get a link to download a zipped file that contains the Pivot Table Builder add-in and the quick start guide. If you have not received the link within 30 minutes, please contact me at ddalgleish@contextures.com

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
    • 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 ddalgleish@contextures.com

Add to Cart

Unconditional 30 Day Guarantee

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

Note

If you have comments or suggestions, please contact ddalgleish@contextures.com

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

Last updated: June 21, 2017 4:38 PM