![complex pivot tables in excel 2013 complex pivot tables in excel 2013](https://cdn.free-power-point-templates.com/articles/wp-content/uploads/2012/12/pivot-table-example.jpg)
If you want to create a new PivotTable so that its Data Cache is separate from the other PivotTables you might have, then you must create it in a particular way. Method 1 (creating a separate Pivot Table report)
#Complex pivot tables in excel 2013 how to#
It tells us how to create a PivotTable in such a way that it already has its own Data Cache and does not share one with the existing PivotTables.Īfterwards I will give you two methods on how to “separate” PivotTables that have already been created. In fact, In this article we will discuss three different ways how to do this.įirst way is linked to the creation of the new PivotTable report. How to change itīoth points listed above are reason enough for the need of a “separation” to arise.
![complex pivot tables in excel 2013 complex pivot tables in excel 2013](https://www.journalofaccountancy.com/content/jofa-home/issues/2018/mar/pivot-table-enhancements-in-excel-2016/_jcr_content/contentSectionArticlePage/article/articleparsys/image.img.jpg)
So you’ve lost the ability to group for example a Date field by months in one PivotTable and by Quarters in another. If you used this field in another PivotTable, it reflects this grouping instantly. The grouping of records within a single field (for example, a Date field that you combine by months or quarters) now cannot be done on an individual PivotTable but immediately effects all the other PivotTables that are related to the same Data Model. Refreshing one individual Pivot Table consequently refreshes all Pivot Tables that are based on the same data, which can be a great thing but you can easily think of some cases where this would not be such a good thing.Ģ. While this solution is obviously a great way to save space on the computer, this also has two quite severe consequences for your Pivot Tables.ġ. It does not create its own Data Cache but rather uses the same one as previous Pivot Tables created on the basis of the same Data Model. Therefore, for each new PivotTable analysis that uses the “same” data, Excel saves hard disk space. 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. The need for indexing and fast creation of analysis has forced it to work in such a manner. The Pivot Table has always created something called Data Cache based on the data provided. For this purpose the creation or better yet the behavior of Pivot Tables has changed since Excel 2003. Of course you would like to make the file size as small as possible. Why does Excel do thisĭuring the creation of Office 2007, 20, a great emphasis was given to the file size. How to separate pivot tables in Excel? In this article we will discuss three different ways how to do this.