Rights Management Services And Sharepoint 2010 RRS feed

  • Question

  • Good Day!

    I sincerely hope that I have posted this in the correct blog, so excuse me if I have posted incorrectly.

    I have the below question about what we are trying to achieve and I was just wondering if anyone has experience with this. 

    The business requirement is to supply users with an excel file containing a pivot table built using data embedded in the excel, users should be able to interact with the pivot table, i.e. drill down change measures filter etc. but should not be able to save their changes or copy content out of the workbook.

    Using SharePoint configured with rights management if I grant a user contributor rights they can interact with the pivot table but can also copy, paste and save changes.

    If I grant a user read rights in SharePoint they can only view the workbook but the pivot table is disabled so they can not interact with the pivot table.

    Question 1:

    Is it possible to change the permissions on the workbook so that they are granular enough to meet the requirements?

    Question 2:

    Assuming I can change the permissions on the workbook and I upload the workbook to SharePoint to a RMS enabled document library will the more granular permissions still apply or will the permission revert back to the sharePoint permissions?

    Any help would be appreciated!



    Tuesday, September 27, 2011 2:08 PM


  • Hi Glenzito,

    I suspect you already after a year and a half have found that the answer to your question was not what you hoped. The granularity of permissions you are looking for here does not currently exist in terms of fine tuning access and control to programmable features such as pivot tables within Excel documents that are assigned Read/View only level of permissions.

    HTH you or others who were possibly wondering about these sorts of questions.

    Brad Mahugh
    Microsoft Corporation
    This post is provided "AS IS" and confers no promises of current or future technical support for a specific support issue. Please use Microsoft product support if you need a service commitment for your current support case or issue.

    Monday, April 1, 2013 8:08 PM