Workbook Security
One of the challenges faced when controlling access to Excel workbooks is allowing users to view specific parts of a workbook while restricting them from viewing or editing the entire workbook. If a user is a member of the default site Visitors group, then they have the rights to view and download workbooks from any document library on the site. Users with these rights could view the entire content of the workbook if it is not otherwise protected. The recommended approach in SharePoint Server is to give users restricted rights on the document libraries that are set up as trusted locations for Excel Calculation Services. Two SharePoint Server permissions control this behavior at the site level: Open Items, which allows users to ...
Get Microsoft® SharePoint® Products and Technologies Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
