#1
|
|||
|
|||
Excel 2013 VBA for Pivot Tables
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Tables | MSA5455 | Excel | 2 | 02-03-2015 06:02 AM |
Disappearing Slicers in power pivot excel 2013 | akaszovitz | Excel | 0 | 11-18-2014 11:22 AM |
Problem With Updating Linked Excel Tables in Word 2013 | maverick1714 | Word | 6 | 09-30-2014 12:30 AM |
Linking Excel Pivot Tables in a Word Document | wmarsh3561 | Word Tables | 0 | 11-17-2009 06:29 AM |