Update PivotCache for Multiple PivotTables
I have my data in sheet "P_Data". The whole data is in a table (Table1). All the pivot tables (9) in this workbook reference to the same data (table1).
Right now I'm manipulating the data through VBA to delete most of the data, except for one condition, then refreshing all the pivot tables and creating a new workbook based on that data.
The problem is that I dont know who to update the pivot cache for all the tables at ones, in that way there is no trace back to the original data source and the slicers get updated only with the filtered information.
Please adivise! Thanks
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Elhadon in forum Excel Programming / VBA / Macros
Last Post: 11-21-2013, 08:48 PM
By rick.hunter.007 in forum Excel Programming / VBA / Macros
Last Post: 10-14-2008, 05:18 PM
By icowden in forum Excel General
Last Post: 10-01-2008, 11:14 AM
By Staaan in forum Excel Programming / VBA / Macros
Last Post: 11-30-2005, 06:55 AM
By Henrik in forum Excel General
Last Post: 10-10-2005, 11:05 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1