Share via


Plan access to Excel spreadsheets

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

In this article:

  • About spreadsheet management

  • Plan a strategy to control access to workbooks and ensure data integrity

  • Plan a strategy to restrict access to individual data objects within workbooks

About spreadsheet management

By using Excel Services in Microsoft Office SharePoint Server 2007, you can control access to workbook data while ensuring data integrity. You can use Excel Calculation Services to enforce centralized management of proprietary information, maintain one version of the truth for Microsoft Office Excel 2007 workbooks, and control how and to whom workbook data is made available based on user permissions.

Depending on the type of access permitted, you can restrict users to View Only permissions, allowing them to view snapshots of workbooks without being able to alter any data in Office Excel 2007. Workbooks that have View Only restrictions still allow users to open, interact with, refresh, and recalculate workbooks in a Web browser. You can also grant open permission to users, which allows them to access and update workbooks.

Plan a strategy to control access to workbooks and ensure data integrity

By configuring View Only permissions, you can ensure that Excel workbooks are only rendered in a Web browser. Users who have View Only permissions can be restricted to opening a snapshot of the workbook in Office Excel 2007.

In Microsoft Office SharePoint Server 2007, you can configure View Only permissions and access restrictions to document libraries in a SharePoint site. This enables you to restrict the availability of workbook data to users who have authenticated access to the site.

Plan a strategy to restrict access to individual data objects within workbooks

Access to selected data objects within a workbook, such as PivotTable components and charts, can be controlled independently from the rest of the workbook when the workbook is published to an application server that runs Excel Calculation Services. The view of the workbook in Excel Services, when rendered in a Web browser, is always the published view, which might be limited to the server-viewable items in the workbook.

Users who have View Only permissions will be able to open only a snapshot of the published items. Users who have full permissions will be able to open the full workbook, including items that have not been designated server viewable.

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for Office SharePoint Server 2007.