Browse » Home
Wednesday, September 19, 2012
How to Remove Old Items in a PivotTable Drop
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.