Plan access to Excel spreadsheets

SharePoint 2007

Updated: February 26, 2009

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:

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.

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.

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.

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.