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

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Our Excel Courses

Professional Input Forms in Excel

  • 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.

Send Emails from Excel

  • 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...
Move Items between ListBox Controls
Tutorial: How to move single items as well as multiple items from one ListBox to another ListBox in ...
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
Macro: Delete a comment in Excel with this macro. You can permanently remove or delete a specific...
Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
Macro: This Excel macro filters data in Excel in order to display the top 10 items from the data ...