Remove Deleted Items from Slicers & Pivot Tables

Add to Favorites
Author: | Edits: don

How to remove items from a Slicer that are not actually in the data set that the Slicer filters.

This becomes important once you start deleting values from your data source for a Table or Pivot Table.

I really don't know why Excel makes us go through the step of changing settings in order to make this work, and I don't know why this is default behaviour for Slicers and Pivot Tables, but, at least its an easy problem to solve.

For more tips on slicers, check out this tutorial: 3 Slicer Tricks for Pivot Tables in Excel

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Remove (Delete) Hyperlinks from Worksheets
Macro: This macro will remove all hyperlinks from the active worksheet. It will delete the hyperl...
3 Slicer Tricks for Pivot Tables in Excel
Tutorial: 3 ways to better use Slicers for Pivot Tables in Excel. These tips will show you how to a...
Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers
Tutorial: Powerful Excel data visualization and analysis that uses a combination of techniques, whi...
Use Pivot Tables and Slicers on Protected Worksheets
Tutorial: How to allow the use of a Pivot Table and its Slicer on a worksheet that is protected. Th...
4 Tips to Camouflage Slicers in Excel
Tutorial: Blend slicers for pivot tables into the design of your spreadsheet. This video tutorial i...
Move Items between ListBox Controls
Tutorial: How to move single items as well as multiple items from one ListBox to another ListBox in ...