Black Friday Sale!

Ends in:

Remove Deleted Items from Slicers & Pivot Tables

Add to Favorites
Author: | Edits: don
BLACK FRIDAY SALE (65%-80% Off)

Excel Courses Online
Video Lessons Excel Guides

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


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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 ...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course