Remove deleted items from a pivot table
In Excel 2019, and Excel 365, you can remove deleted items by changing a pivot table setting:
Set option for all new pivot tables
To change this setting for all new pivot tables:
Older Excel versions
Older versions of Excel don’t have the setting shown above. To remove deleted items, you’ll need to use a macro. Debra Dalgleish has a detailed explanation here. Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
