I need to understand the VBA needed to do it.
I have the code to create the cache and the pivot tables on one page, but I don't want to create a new cache on each sheet. I want to be able to create one cache, then use that one cache to create many pivot tables.
Help?![]()
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=XSourceData, Version:=xlPivotTableVersion14).CreatePivotTable TableDestination:="'Test'!R5C1", TableName:="Test", DefaultVersion:=xlPivotTableVersion14
Bookmarks