The invoked drop-down menu allows you to apply one of the following layout forms. Compact Form - the default layout. The report is compressed to prevent data from spreading horizontally off the screen ...

You can update (refresh) the PivotTable data manually (while generating the report) or automatically (when you open the workbook with the pivot table). The steps below provide more detailed ...