Cannot add an "Excel Web Access" Web Part in SharePoint Online

  If you are not seeing the option to add an Excel Web Access Web Part under the Business Data Category:     Make sure to enable Custom Script under Admin > SharePoint > settings >   The new “Custom Script” (no-script) featurehttp://blogs.msdn.com/b/sridhara/archive/2015/04/02/the-new-custom-script-no-script-feature.aspx Turn scripting capabilities on or offhttps://support.office.com/en-us/article/Turn-scripting-capabilities-on-or-off-1f2c515f-5d7e-448a-9fd7-835da935584f As you can see, if this is…

0

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