Skip to end of metadata
Go to start of metadata

To modify an existing pivot table, simply bring the mouse over and press right-click. Choose 'edit' from the right-click menu. It will invoke the pivot table wizard populated with selections for the current pivot.

You can remove the pivot table from the workbook by selecting 'delete' from the right-click menu.

Once a pivot table report is created it uses a static instance of the source data. It means if the source data is modified it will not update the results presented in the pivot table. By pressing 'refresh' from the right-click menu, you can have SpreadsheetLIVE reload the latest data from the source range.

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.