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

Chapter 27. Using the Power of Pivot Tables > Saving Files with Pivot Tables

Saving Files with Pivot Tables

Sometimes files with pivot tables are surprisingly large because Excel creates a copy of the source data and stores it as hidden data with the worksheet that contains the pivot table. If your pivot table references a large amount of data in another file, you store the same data twice whenever you save the file that contains the pivot table.

To avoid this replication, deselect the Save Data with Table Layout check box in Step 4 of the PivotTable Wizard. Excel then saves the pivot table layout but omits the copy of the source data. When you make changes to—or refresh—the pivot table, Excel updates it directly from the source data. Note that when you use a pivot table that has the data saved with it as the source for another pivot table, the data is no longer saved with the original pivot table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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