Related Tutorials
Excel > Excel 2003 Advanced > PivotTables and PivotCharts
PivotTable Options
PivotTable options allow you to control the behaviour of a PivotTable. Options include preserving the formatting on refresh, the use of subtotals and enabling show details.
To change PivotTable options:
- Click in the PivotTable
- Click the PivotTable button on the PivotTable toolbar and select Table Options
- Change the desired options
- Click Ok
The PivotTable Options dialogue box is displayed.