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

Chapter 12. Working with PivotTable and ... > Exporting the PivotTable to Excel

Exporting the PivotTable to Excel

You can export the PivotTable as a FileName.htm file, together with supporting .xml, .htm, and .css files, to a pseudo-PivotTable in an Excel workbook. This isn't a very exciting feature, because the process exports the data as a static XML rowset (Cachedata.xml in the . . .\FileName_files folder). The temporary workbook is read-only and doesn't update as the underlying data from the query changes.

Click the Export to Microsoft Excel button to generate the PivotTable workbook. Figure 12.21 shows the default view of the PivotTable exported to Sheet1 of a workbook with the Excel PivotTable toolbar and PivotTable Field List displayed. Excel's PivotTable toolbar is similar to Access's; for example, Excel's Show Detail and Hide Detail buttons correspond to Access's Expand and Collapse buttons. Sheet 2 contains data exported by the source query of the PivotTable, which Excel translates from the Cachedata.xml file.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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