Excel Online – "Unable to Set One or More Parameters" when connecting "Excel Web Access Web Part" and "Current User Filter"

I recently came across the error: I was connecting a Current User Filter to an Excel Web Access Web Part I was trying to pass the User's Login Name via the Current User Filter to a Parameter in an Excel Web Access WebPart. I first created a workbook that contained a Pivot Table and then gave one of…

12

Excel Online – PivotTable Operation Failed

I recently worked with a customer who was clicking on a slicer in an Excel Online PowerPivot workbook and getting the below error: After many days of analyzing logs, it was determined the cube was showing as being "Unprocessed".  Therefore the refresh could not complete.  The fix was to re-calculate the workbook (in PowerPivot).   To do this, you will need…

2