• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Pivot Table Fundamentals > Pivot Tables Behind the Scenes

Pivot Tables Behind the Scenes

As you might have guessed, all of this awesome functionality is not free. It's important to know that pivot tables do come with a few file space and memory implications for your system. To get an idea of what this means, let's take a look at what happens behind the scenes when you create a pivot table.

When you initiate the creation of a pivot table report, Excel takes a snapshot of your dataset and stores it in a pivot cache. A pivot cache is nothing more than a special memory sub-system in which your data source is duplicated for quick access. Although the pivot cache is not a physical object that you can see, you can think of it as a container that stores the snapshot of the data source.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint