Sunday, February 13, 2011

How to Disable the Functions of a PivotTable


1. Open Excel and then open the workbook that contains the PivotTable you would like to disable.
2. Right-click on any cell within the PivotTable and then click 'PivotTable Options.'
3. Click the 'Display' tab and then uncheck the selections for 'Show expand/collapse buttons,' 'Show contextual tooltips,' ' Display field captions and filter drop downs,' 'Classic PivotTable layout (enables dragging of fields in the grid)' and 'Display item labels when no fields are in the values area.'
4. Click 'OK.'

Blogger news