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
NOTE: The Pivot Table Builder tools are also in the Pivot Power Premium add-in. (version 4 and later)
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.
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.
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.
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.
Create as many lists as you need -- one for each pivot table variation that you want to apply quickly.
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.
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.
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.
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.
You can also select a default layout for the new pivot tables that you create with the Pivot Table Builder -- Compact, Outline or Tabular.
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.
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.
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.
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.
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.
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 firstname.lastname@example.org
There are installation instructions in the User Guide.
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.
If you have comments or suggestions, please contact email@example.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