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

How do I turn my pivot table into hard data?

How do I turn my pivot table into hard data?

Problem

You only created your pivot table in order to summarize and shape your data. You do not want to keep the source data, nor do you want to keep the pivot table with all its overhead.

Solution

Turning your pivot table into hard data allows you to utilize the results of the pivot table without having to deal with the source data, or a pivot cache. How you turn your pivot table into hard data depends on how much of your pivot table you are going to copy.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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