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

Chapter 2. Creating a Basic Pivot Table > Keeping Up with Changes in Your Data ...

Keeping Up with Changes in Your Data Source

Let's go back to the family portrait analogy. As years go by, your family will change in appearance and may even grow to include some new members. The family portrait that was taken years ago remains static and no longer represents the family today. So another portrait will have to be taken.

As time goes by, your data may change and grow with newly added rows and columns. However, the pivot cache that feeds your pivot table report is disconnected from your data source, so it cannot represent any of the changes you make to your date source until you take another snapshot.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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