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. [...]
Slicers were introduced in Excel 2010 for PivotTables. What are slicers you ask? If you don't know, well, you're in for a treat. Here is some background information to bring you up to speed. Introducing Excel 2010 Slicers Use slicers to filter PivotTable data Excel 2010 Slicers by Mike Alexander PivotTable Slicers by Jan Karel [...]
This blog post will be based on working with tables via VBA. They present some unique issues, which has to do with how their structured in the object model. Good or bad, it's what we have. These are based on my trial and errors, so hopefully this will help somebody out there. That being [...]