Search Contextures Sites

Excel Pivot Tables Add-In -- PivotPower The PivotPower add-in helps you by automating many of the features that aren't built in to an Excel pivot table, and by making some of the buried Excel pivot table features easier to access. For example, you can quickly clear old items from an Excel pivot table, or hide all the grand totals, or change all the data fields from using the Count function to using the Sum function. You can download a free copy of the PivotPower add-in at the link below, and install it by following the steps outlined below. Add-In Features The PowerPivot add-in for Excel pivot tables creates a PIVOT menu on the Excel menu bar, and adds several functions that will help you format and automate the pivot tables in your workbook. For example, instead of writing a macro to protect the pivot table, and prevent users from making any changes to the pivot table, you can simply click the Restrict Features command on the PIVOT menu. You can also reset the pivot table captions, so they go back to the originals settings, or see when the pivot table was last refreshed. With the PIVOT menu, it will be easy to print a copy of the pivot table for each item in the page field, or remove all the drop down lists from the row, column and page fields. You can read a full description of the Excel pivot table Add-In features. Download PivotPower.xla add-in Beta 2.7 Click here to download the PivotPower pivot table add-in file To install the PivotPower Pivot Table Add-in: Download the zipped copy of the PivotPower pivot table add-in file Unzip the PivotPower file, to extract the PivotPower.xla file. Save the PivotPower.xla file in your Microsoft\Addins folder. For example, in Windows XP, this folder might be located here: C:\Documents and Settings\Contextures\Application Data\Microsoft\AddIns Open the Excel program Click the Tools menu on the menu bar, and click the Add-Ins command. In the Add-in dialog box, click the Browse button Navigate to the Addins folder, and select the PivotPower.xla add-in file Click OK, click OK A PIVOT menu will appear on your Excel menu bar. Use the commands on the PIVOT menu to perform tasks with your pivot tables, such as clearing the old items, and removing all the subtotals. No Help is available for the PivotPower Beta version. If you have comments or suggestions, please contact ddalgleish@contextures.com

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 ©2010 All rights reserved.	Debra Dalgleish