I have a worksheet with several pivot tables and corresponding pivot charts. There is a macro that I have in this file, which automatically appends data from another location into this workbook. But at the end of the macro, I would like to have each pivot table update automatically within a specific field (the field is called "Date", and is used as the "x-axis" in a corresponding Pivot Chart.).



Basically, if I did this manually, I would go into each individual pivot table and click on the (Select All) item within the "Date" field filter; then in the same "Date" field I would then un-click the (blank) item way down at the bottom of the field filter list.

How do I pull off the need outlined within the paragraph above with VBA? Again, I have about 20-or-so Pivot Charts within this workbook. I also have other Histogram charts that are in need of the same filtering abilities for their respective fields.

Thanks