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:

enter image description here

enter image description here


Did you specify the workbooks to use the Secure Store Service ID in the data connection? It should be under the authentication settings...

enter image description here

| improve this answer | |
  • Yes I did. If I hadnt then it wouldnt show up in the Excel web access web part in the first place. – user7400 Aug 6 '12 at 16:34
  • Are you using a SQL Server account login for the Secure Store Service Application ID? – Mike Aug 6 '12 at 16:51
  • Regardless, does the Secure Store Service Application identity have proper access to the SSAS or SQL database it's trying to reach? – Mike Aug 6 '12 at 17:19
  • yes i am using a service account that does have access to the database. Like I mentioned before, if the service account and the SSID werent configured properly it wouldnt open and would throw an error while opening up in the Excel web access web part. – user7400 Aug 6 '12 at 17:41
  • The error it's giving you is specific to permissions, if it was set up correctly, it wouldn't be throwing that error. What authentication is your front-end using? – Mike Aug 6 '12 at 17:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.