PowerPivot Slicers in Excel Services Web Part RRS feed

  • Question

  • I have SharePoint 2010 Enterprise using Excel 2010 and I have PowerPivot for Excel installed. I created some charts and slicers and a worksheet and uploaded them to the PowerPivot Gallery I setup. If I click on the spreadsheet to open it up directly in the browser, the slicers work, but when I use the Excel Services Web Part to display the spreadsheet, the slicers don't work. I have read that slicers are supposed to work in the web part, so I'm not sure what is going on.

    Update: Just wanted to point out that by not working, I mean the slicers show up, but you can't click any of them. It's just a static image. Also I have some issues even when I open the spreadsheet directly in Excel Services. I get a data refresh error when choosing a slicer, but at least I have the ability to use the slicers so I assume this is a different issue. I just wanted to confirm that the slicers are in fact supposed to work in the Excel Services Web Part.

    Thursday, July 10, 2014 8:01 PM


All replies