Since it’s a replica of the source data, when you create a pivot table, a copy of that data gets stored in the Pivot Cache. One downside of pivot cache is that it increases the size of your workbook. This is also the reason you need to refresh the pivot table to reflect any changes made in the data set. While you think that you are directly linked to the source data, in reality, you access the pivot cache (and not the source data) when you make changes in the pivot table. Pivot Cache enables this fast functioning of a pivot table. You can drag and drop items in the rows/columns/values/filters boxes and it will instantly update the results. Even when you have thousands of rows of data, a pivot table is super fast in summarizing it. The reason a pivot cache gets generated is to optimize the pivot table functioning. While you can’t see it, it is a part of the workbook and is connected to the Pivot Table. When you make any changes in the Pivot Table, it does not use the data source, rather it uses the Pivot Cache. It is an object that holds a replica of the data source. Pivot Cache is something that automatically gets generated when you create a Pivot Table. Improving Performance while Working with Pivot Tables.Creating Duplicate Pivot Cache (with the same Data Source).
0 Comments
Leave a Reply. |