Press the Field List button in the Show section to toggle the Pivot Table Fields window on or off.You can also close the Pivot Table Fields window using the X in the upper right corner.I’ve posted several examples of manipulating pivot tables with VBA, for example, Dynamic Chart using Pivot Table and VBA and Update Regular Chart when Pivot Table Updates.These examples included specific procedures, and the emphasis was on the results of the manipulation.Last December, I described how to add code to your workbook, so if you changed one pivot table filter, all the other pivot tables in the workbook would change too.
Click on the gear wheel with a downward arrow to change default appearance of the Pivot Table Fields window.
This collection of awesome tips and tricks will help you master pivot tables and become a data ninja!
Download the example file with the data used in this post to follow along.
I thought it would be helpful to show some of the mechanics of programming with pivot tables.
One important part of this is referencing the various ranges within a pivot table by their special VBA range names (which are actually properties of the Pivot Table object).
When you add data to the table, you won’t need to update the range in your pivot table.