SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 0 down vote accepted

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

share|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 posting your answer, you agree to the privacy policy and terms of service.

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