MS Excel PivotTable Deleted Items Remain
PivotTable's are a wonderful thing, but they have their downsides. One of them is the fact that they will retain deleted data from the data source, which shows up in filter drop downs and slicers. This can be slightly (up to extremely) annoying and hard to find where to not show pesky deleted items. [...]