A user can export a pivot grid to Microsoft Excel as a read-only file for further analysis as needed. Pivot Grids export data to Excel as a flat file. That is the information not carried across as a pivot table, but data exported as static rows and columns.
Follow these steps:
Click the EXCEL icon located in the pivot grid toolbar.
Pivot grid views do not support the automatically refreshment of table data supported in pivot tables. |