Excel -- Pivot Tables -- Add-In -- Features The following features are contained in the PivotPower Add-in, that you can download by clicking the link at the right. Installation instructions are shown here. Download the PivotPower.zip file	Amazon.com  Amazon.ca  e-book

Grand Totals   Subtotals Formatting   Pivot Items   Page Fields

Data Fields    Select Restrict Features   Printing   Information

Grand Totals Use these commands to hide or show the Row Grand Totals, Column Grand Totals, or both.

Subtotals Use these commands to hide or show the Row subtotals, Column subtotals, or both.

Formatting 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. 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.

Page Fields 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. 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 21-Ju1-06 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.

Select 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. Disable All Selection This command removes the dropdown lists from the pivot field buttons. Enable All Selection This command restores the dropdown lists to the pivot field buttons

Restrict Features Restrict All Features This command prevents use of the following features: Pivot Wizard Drilldown Field List Field Dialog Refresh Field Dragging Allow All Features This command restores use of the features listed above.

Printing 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 selected 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 selected 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 there are multiple pivot tables on the active sheet, a message will appear for each pivot table.

PivotPower Download Instructions

Home     Excel Tips     Excel Files      Blog    Contact
		The Excel Store	Debra Dalgleish