Forum Discussion
weird issue with pivot tables not clearing data
I have an existing pivot table data for a number of individuals. They are included in the pivot table as rows. Now I've taken that spreadsheet and created a copy. I want to make a new spreadsheet,...
Hello geekdad
1. Click any cell in pivot table, and right click, choose PivotTable Options from the context menu,
2. In the PivotTable Options dialog box, click Data tab, and then choose None from the Number of items to retain per field drop down list,
3. And then click OK to close the dialog box, and refresh the pivot table, now, when you click the Filter arrow, the old item has been cleared at once.
Hope this helps.