Pivot Power Premium FAQ
This page shows Frequently Asked Questions (FAQs) about the Contextures
Pivot Power Premium add-in. If you have a question that is not answered
here, send an email to
Debra Dalgleish -- ddalgleish @ contextures.com
Sharing the Workbooks
What's New in PPP?
Back to Help Page
NOTE: This page is under construction -- more information will be added
Sharing the Workbooks
The Pivot Power Premium add-in is licensed for one user, so the add-in
file cannot be shared with others.
However, you can share any workbooks that you create, in which you
used the Pivot Power Premium add-in. Other users will be able to use
those workbooks, like any other Excel file -- they do not need the
Pivot Power Premium add-in in order to use the completed workbooks.
The Pivot Power Premium add-in will work in 64-bit Excel, but you
might see a dialog box that prompts you to enter a password. This
is a known problem with password protected Excel add-ins in 64-bit
Excel, so just click Cancel, and the add-in should work correctly.
It is annoying, but nobody has reported finding a solution for this
What's New in PPP?
The following changes were made in Version 5.04
- Restrict/Allow – Another minor adjustment to these macros
- Change Cache – List now shows only the caches for Normal pivot tables. Message explains that Data Model caches cannot be changed with PPP.
The following changes were made in Version 5.03
- Restrict/Allow – Changed macros to work with Data Model pivot tables
The following changes were made in Version 5.02
- Pivot Prefs – While the form is open, you can use Ribbon commands, to check Pivot Table Styles
- Change ALL to: Distinct Count was added - only works with Data Model pivot tables
- Change SEL to: Distinct Count was added - only works with Data Model pivot tables
- Value Headings - ALL: Creates simple headings for Data Model pivot tables, instead of bracketed names.
- Value Headings - SEL: Creates simple headings for Data Model pivot tables, instead of bracketed names.
The following changes were made in Version 5.01
- Pivot Prefs – The “Set Prefs” command on the ribbon was renamed as Pivot Prefs
- Pivot Prefs Form: Title was changed to Set and Apply Preferences
- Pivot Prefs Form: Custom Pivot Table Styles can be stored and applied. NOTE: If the selected custom style is not in the active workbook when you try to apply it, the “None” style will be applied.
The following features were added in Version 5.00
- Set Prefs – There are 10 new settings in the Set Prefs form, and the Pivot Table settings were split into tables for Pivot Table Format and Pivot Table Data
- Get Pivot Table Settings – Select a pivot table cell, then open the Set Prefs form, and click the new “Get PT Settings” button. The options and format settings from that pivot table are copied into the preference setting.
- Apply Prefs – The Apply Prefs steps are simpler now.
- Set Prefs: Select a Pref Setting number at the top of the form, to see all its settings, and adjust if necessary. Choose options at the bottom, for which settings you want to apply, and where. Then, click Save & Apply.
- PPP Tab: There are 2 buttons on the Ribbon’s PPP tab, to apply your #1 Pref settings to either the selected pivot table, or all pivot tables in the workbook.
The following fixes were made in Version 4.03
- Value Headings SEL – Fixed problem of “2” occasionally being added to the first Value field name, when “Sum of” was removed.
- Value Headings ALL – Fixed problem of “2” occasionally being added to the first Value field name, when “Sum of” was removed.
- Set Prefs - Pivot Field tab – under Value Headings, add a check mark if you want to remove "Sum of" (or Count of, etc.), from all the Value fields
- Set Prefs - Workbook tab – 2 new check boxes:
- Show Pivot Field List – add a check mark and the Pivot Field list will be visible when any pivot table in the active workbook is selected. You can also right-click on a pivot table, and show or hide the field list.
- AutoFilter Grouping – add a check mark to have dates grouped by year and month, in the drop down lists in your source data headings. Remove the check mark to see the individual dates listed.
- Value Headings SEL – remove "Sum of" from selected value field headings only – leave other headings as is. Also, improved handling of multiple copies of the same field in the layout, for the Value Headings ALL command.
- Pivot Table Builder (PTB) – include captions when creating field list from a pivot table. Also, improved handling of multiple copies of the same field in the layout.
- Pivot Table Builder (PTB) – create PTB lists based on a pivot table or a named Excel table. Create a new pivot table, or update an existing pivot table, based on one of the PTB lists in the workbook.
- Export/Import Prefs – Store your preferences externally, them export or import them when installing a new version of PPP (In the Set Prefs form)
- Show SEL As – apply calculations, such as Running Total In, Rank Largest to Smallest (NOTE: will only apply calculations supported in your version of Excel)
- Remove All Selected Value Fields – select one or more fields in the Values area, and remove them with a single click (On the Pivot Fields drop down)
- Resources – Links to the PPP Help page on the Contextures website
- Changed: The Apply Prefs commands have been split into 3 options:
- Apply 01 – apply the #1 Preference Settings, to the location selected in the drop down list (similar to Apply Prefs in previous versions)
- Apply Sel PT – select a preference setting, and apply to specified location in selected pivot table / worksheet
- Apply ALL PT – select a preference setting, and apply to specified location in all pivot table / worksheet
- Fixed: Source Number Formatting (was not completing all preference settings)
- Added: Pivot Table Info – Create detailed list of settings and options used in the selected pivot table
- Ribbon tab label was changed to PPP (previously Pivot Power), so it takes less room on the Ribbon
- A few commands were moved, to reduce the Ribbon width, and to keep similar commands together
- Store, name, and apply up to 5 Preference Settings (only 1 was stored in previous versions). For example:
- Prefs #1 could have Medium 8 as the style, with Tabular layout, and use Number format with zero decimals. It could be named based on its settings, such as "Med8 Tab Num0", or any other type of name, such as "Marketing Rpts".
- Prefs #2 could have Light 3 as the style, with Outline layout, and use Number format based on the source data.
- Create a list of all the stored Preference Settings, to see them all at a glance.
- Number Formatting – Format ALL – Number Source. Copies the number formatting from the first row in the source data, if that data is stored in the same workbook as the pivot table.
- Pivot Fields and Items – Pivot Fields – Value Headings. Changes the heading for all Value fields, to remove Sum of, Count of, etc. Changes the heading label to the source data Field name with a space character at the end
- Filters and Cache – Filter – Sort Report Filters. Quickly sort all items in each field in the report filters. (Solves the problem of report filters not having a Sort command).
Back to Help Page