- 1). Right-click on any cell in the PivotTable.
- 2). Click "PivotTable Options" from the drop-down menu. A small window will appear.
- 3). Select the "Data" tab at the top of the new window.
- 4). Click on the drop-down arrow under the "Retain items deleted from the data source" areas. Choose "None" from the list and click "OK" at the bottom of the window.
- 5). Select the "Options" tab at the top of the screen, directly underneath "PivotTable Tools."
- 6). Click "Refresh" in the "Data" area of the toolbar. Your PivotTable should briefly flash and all deleted entries will now be removed from drop-down boxes in the PivotTables.
next post