Answered by:
PowerPivot Slicers in Excel Services Web Part

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.
- Edited by Michael Kubala Thursday, July 10, 2014 8:11 PM
Thursday, July 10, 2014 8:01 PM
Answers
-
Hi Michael,
Please check the link below, and scroll down to “Adding Interactivity Using a Slicer”:
http://msdn.microsoft.com/en-us/library/gg697767(v=office.14).aspx#ExcelServ_Demonstration
And post the data refresh error for further troubleshooting. Here is the possible scenario for failed data refresh:
Regards,
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com .
Rebecca Tu
TechNet Community Support- Marked as answer by Michael Kubala Wednesday, July 16, 2014 9:09 PM
Friday, July 11, 2014 8:29 AM
All replies
-
Hi Michael,
Please check the link below, and scroll down to “Adding Interactivity Using a Slicer”:
http://msdn.microsoft.com/en-us/library/gg697767(v=office.14).aspx#ExcelServ_Demonstration
And post the data refresh error for further troubleshooting. Here is the possible scenario for failed data refresh:
Regards,
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com .
Rebecca Tu
TechNet Community Support- Marked as answer by Michael Kubala Wednesday, July 16, 2014 9:09 PM
Friday, July 11, 2014 8:29 AM -
Hi Michael,
Please check the link below, and scroll down to “Adding Interactivity Using a Slicer”:
http://msdn.microsoft.com/en-us/library/gg697767(v=office.14).aspx#ExcelServ_Demonstration
And post the data refresh error for further troubleshooting. Here is the possible scenario for failed data refresh:
Regards,
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com .
Rebecca Tu
TechNet Community SupportWednesday, July 16, 2014 9:09 PM