Saturday 14 August 2010

Macro Quickly Formats Excel Pivot Table

Title:
Macro Quickly Formats Excel Pivot Table


Video:


Description:www.contextures.com After you create an Excel pivot table, you probably make several changes to its formatting, and to the pivot table options, and that can take a few minutes per pivot table. Instead of doing the steps manually, you can use a macro. In this video you'll see the steps for manually formatting a pivot table, compared to the speed of running the Classic Pivot Table Formatting macro from Bob Ryan, of SimplyLearningExcel.com You'll see the manual steps required to format the pivot table in Classic Style -change the subtotal setting -change the report layout -change the pivot table style -change the pivot table display options -change the setting to prevent old items in the drop downs -format each value field as number format -sort each row field alphabetically. Then, see how much quicker it is to run the recorded macro, to format the pivot table in seconds, instead of minutes. If you record your own macro while make the changes to the pivot table, you will need to edit that macro, so it works on any pivot table, no matter what the field names are, or where the pivot table is located. View Bob's code to see how he uses variables to make the code work on any pivot table. You can view the Excel pivot table formatting macro used in the video: www.contextures.com

Published:
15/Aug/2010

No comments:

Post a Comment