Search Contextures Sites

Excel Pivot Table Add-In -- PivotPower Features

The following features are contained in the PivotPower Add-in, that you can download by clicking the link below. Installation instructions are on the PivotPower Add-in Installation page. Download the PivotPower.zip file  In Excel 2007 and Excel 2010, the PivotPower menu appears on the Ribbon's Add-ins tab. March 8, 2011: For most commands, only the selected pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the active sheet will be affected by the command. Dec 2, 2011: New Info features have been added, and the VBA password is available for a small fee.

Buy the PivotPower VBA Password ($10 US)   Download the PivotPower add-in at no charge..

Grand Totals   Subtotals Formatting   Pivot Items   Page Fields

Data Fields    Select Restrict Features   Printing   Information   Purchase the VBA Password

Grand Totals Use these commands to hide or show the Row Grand Totals, Column Grand Totals, or both. If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected.

Subtotals Use these commands to hide or show the Row subtotals, Column subtotals, or both. If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected.

Formatting If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected Reset Captions If captions have been changed from their original text, this command restores the original text. Change (Blank) to Space If pivot items appear with the text "(Blank)", this command changes the items to a space character. Change (Blank) to Text If pivot items appear with the text "(Blank)", this command prompts you to provide other text, e.g. "N/A".

Pivot Items Clear Old Items The data in the pivot table source may change, and items that were previously in the source are no longer included. This command removes the old items from the pivot table. If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected Show / Hide All Items In versions previous to Excel 2002, where there is no Show All checkbox, you can use these commands to show or hide all items in a field. Select a cell in the pivot table, then choose the command -- you will be prompted to select a pivot field. If a pivot table cell is selected, only that pivot table will be affected. A UserForm will appear, where you can select the pivot field for which you want to show/hide items. If the active cell is not in a pivot table, the command will not work.

Page Fields If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected (exception: Show Next Page Item command). Show Next Page Item If a Page field has a long list of items, this command may make it easier to select the next item. If the active cell is not in a pivot table, the first pivot table in the active sheet will be affected. Set Pages to (All) Quickly reset all page fields, in all pivot tables on the active sheet, to (All). Show /Hide All Page Field Items To show or hide page field items, you can double-click on the page field button, and select items to show or hide. This command shows or hides all items in all page fields in the active pivot table. (Note: If Hide All is selected, the last item will remain visible.)

Data Fields 30-Oct-08 When you add fields to the Data area, fields default to the Count function or the Sum function. These commands change all Data fields to the selected summary function. If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected.

Select Pivot Table If there is one pivot table on the active sheet, it will be selected. If there are more than one, a UserForm appears, and you will be prompted to select a specific table. Disable/Enable All Selection Removes/restores the drop down lists from the pivot field buttons. If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected

Restrict Features If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, all pivot tables on the sheet will be affected. Restrict/Allow All Features This command restricts/restores use of the following features: Pivot Wizard Drilldown Field List Field Dialog Refresh Field Dragging

Printing If a pivot table cell is selected, only that pivot table will be affected. If the active cell is not in a pivot table, the first pivot table on the sheet will be affected. Print Pivot Table If there is one pivot table on the active sheet, it will be selected. If there are more than one, you will be prompted to select a specific table. Then, you will be prompted to choose Print or Preview. Print Each Page Field If there is one pivot table on the active sheet, it will be selected. If there are more than one, you will be prompted to select a specific table. Then, you will be prompted to choose Print or Preview. The pivot table is then printed/previewed for each page field item.

Information Select a command, and a message displays the selected information. If a pivot table cell is selected, information for that pivot table will be displayed. For the 'Active Cell PivotTable' command, if a pivot table cell is not selected, a warning message will appear. For the Pivot Cache Count command, a message box shows the count of pivot caches in the active workbook. For the List Pivot Tables command, a new worksheet is added, with a list of pivot tables in the active workbook. For the other Information commands, if the active cell is not in a pivot table, information will be displayed for each pivot table on the active sheet.
Purchase the VBA Password If you want to tweak the PivotPower code, or add your own macros to the add-in, you can purchase the VBA password, to unlock the code. Details The price for the VBA password is $10 US. You are ordering the PivotPower VBA password only. After you pay for the VBA password, you will download a zipped file that contains a PDF file with the password, and a few notes about how the PivotPower add-in works. $10 US Note You must be familiar with VBA in order to modify the code in this add-in. Limited technical support is available via email. There is no free programming help for those who have purchased the VBA password, and want to customize the PivotPower add-in.	Buy the PivotPower VBA Password ($10 US)   Download the PivotPower add-in at no charge..
	PivotPower Download Instructions

Pivot Table Tutorials Excel Pivot Table -- Introduction  Excel Pivot Table -- Clear Old Items Excel Pivot Table -- Create a Pivot Table in Excel 2007  Excel Pivot Table -- Custom Calculations  Excel Pivot Table -- Data Field Layout Excel Pivot Table -- Dynamic Data Source Excel Pivot Table -- FAQs Excel Pivot Table -- Field Settings Excel Pivot Table -- Filter Source Data   Excel Pivot Table -- Filters, Top 10  Excel Pivot Table -- GetPivotData Excel Pivot Table -- Grand Totals Excel Pivot Table -- Grouping Data Excel Pivot Table -- Layout, Excel 2007 Excel Pivot Table -- Multiple Consolidation Ranges Excel Pivot Table -- Pivot Cache    Excel Pivot Table -- PivotTable Style Excel Pivot Table -- Printing    Excel Pivot Table -- Protection   Excel Pivot Table -- Report Filters Excel Pivot Table -- Running Totals   Excel Pivot Table -- Show and Hide Items  Excel Pivot Table -- Sorting Excel Pivot Table -- Subtotals  Excel Pivot Table -- Summary Functions Excel Pivot Table -- Unique Items

Pivot Table Books Pivot Tables, Beginning (Excel 2007)  Pivot Tables, Recipe Book (Excel 2003)  Pivot Tables, Recipe Book (Excel 2007)  Pivot Table Add-Ins Pivot Tables - Add-in -- Pivot Power  Pivot Tables - Add-in - Pivot Play PLUS  Pivot Table Videos Pivot Tables - Clear Old Items Pivot Tables - Copy a Custom PivotTable Style Pivot Tables - Create in Excel 2007 Pivot Tables - Create from Multiple Sheets Pivot Tables - Data Field Layout Pivot Tables - Date Filters, Add Pivot Tables - GetPivotData Pivot Tables - Group Data Pivot Tables - Layout, Excel 2007 Pivot Tables - Report Filters, Add Pivot Tables - Running Totals Pivot Tables - Select Sections Pivot Tables - Subtotals, Create Multiple Pivot Tables - Top 10 Filters

 

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright ©2012 All rights reserved.	Debra Dalgleish