Unshare Data Cache Between Pivottable. Paste it into the previous file. Unshare a data cache between PivotTable reports.
To create a separate pivot cache for the second pivot table. I also found some articles about slicer and data cashe for pivot table. To use different grouping in each pivot table youll need to create a separate pivot cache for each pivot table.
When prompted to base the new report on an existing pivot table click No.
Ads Organization Getting Organized Organisation Organization Getting Organized Organisation. In Excel 2003 each Pivot Table had its own Data Cache but now the Pivot Table that is created using the same Data Model or Data Source as another previously created Pivot Table also borrows that Pivot Tables Data Cache. If your data is not in an Excel table and the data source is already cached by an existing PivotTable you will be given the option to either share or not share. Unshare the data cache between PivotTable reports that are based on a cell range by temporarily redefining.