My question is essentially the title. I have a requirement to restrict people from viewing the base excel workbook due to potentially sensitive information. However, I need to be able to display certain named parts from the workbook via and Excel Web Access web part. Would a user without read permissions on the excel file be able to see the view specified by the web part, or do they need read access to view?

  • they need read access to the file – Eric Alexander Feb 20 '15 at 17:55

If they do not have SP-read permissions to the .xlsx file, then EWA will not show it to them either.

The only idea I can think of is to make an extract of the "safe data" and show that in EWA.

| improve this answer | |
  • That is a bummer. That is what I was guessing, that we will just need to "scrub" the sensitive information (such as names). Thanks! – bmartin Feb 20 '15 at 19:11

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.