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.