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 have created an Secure store ID for the workbooks and they work just fine
Please advise.
Here are the screenshots: