Auto updating pivot table
I hope you had a safe and happy New Year’s Eve celebration, and are off to a good start in 2012. To see the steps for copying the code into your worksheet, and an explanation of how the code works, you can watch this short Excel video tutorial.Things got a bit rowdy at the Contextures office party, and I found these guys passed out on the floor, the next morning. If any other pivot tables in the workbook have an “Items” filter, the “Select Multiple Items” setting for those fields will also change. The multiple pivot table filtering works with event programming.
Another useful feature of these collapse / expand buttons in pivot tables is that, when you make a pivot chart, the collapsed groups are collapsed in the pivot chart too.
In this version of the sample file, the “Select Multiple Items” setting is also changed, to match the setting that is in the pivot table that you changed.
In the screen shot below, the Item field has the “Select Multiple Items” setting turned off.
At Chandoo.org, I have one goal, "to make you awesome in excel and charting".
This blog is started in 2007 and today has 450 articles and tutorials on using excel, making better charts.