I've got a Pivot Table that is pulling data from PowerPivot and for some reason it won't insert a slicer. I select the slicer I want and when I click OK, nothing happens. I've checked the data source and everything seems to be working fine. One other thing to note. If I have an old slicer and I try to connect it to my new Pivot Table, I get the following error: "This PivotTable report is invalid. Try Refreshing the data."
Any thoughts?
Bookmarks