I am able to view and filter data based off excel fileters via the Excel Web Access web part for Excel workbooks. However, when I "open in Excel" it does not allow me to filter or edit. Note: I ...
I am able to upload reports in a sharepoint library that have embedded data connections to a cube(SQL2008\AnalysisInstance). We are not using power pivot. We are running Sql 2008 standard version. ...