I have 7 pivottables in my workbook. They use the same data source and currently they all share the same pivot cache.
Can I make it so that 3 pivottables share a pivotcache and 4 pivottables share another pivotcache? I can't find a "pivotcache"-setting anywhere.
Bookmarks