Great post guys. It seems that this only works when you are connected to a traditional pivot table and not to the data model. I get an 1004 error in that situation. I looked at the properties of a slicer connected to a traditional pivot table and a a slicer connected to a power pivot model and...