Remove Deleted Items from Slicers & Pivot Tables
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
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.)
Macro: This macro will remove all hyperlinks from the active worksheet. It will delete the hyperl...
Tutorial: 3 ways to better use Slicers for Pivot Tables in Excel. These tips will show you how to a...
Tutorial: Powerful Excel data visualization and analysis that uses a combination of techniques, whi...
Tutorial: How to allow the use of a Pivot Table and its Slicer on a worksheet that is protected. Th...
Tutorial: Blend slicers for pivot tables into the design of your spreadsheet. This video tutorial i...
Tutorial: How to move single items as well as multiple items from one ListBox to another ListBox in ...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)