Beginning SharePoint 2007: Building Team Solutions with MOSS 2007 (Programmer to Programmer)

Overview

Microsoft Excel is a familiar application that many companies use for data entry and reporting. However, Excel was originally designed for desktop use, and so it is difficult to share a spreadsheet among several users who are collaborating on a project. Typically, the owner of the spreadsheet places it in a shared folder on a file server so that other team members can retrieve, modify, and update it. While this approach can work, it requires a great deal of diligence to maintain the spreadsheet’s integrity; the owner has no way to prevent a user from intentionally or accidentally changing a formula or a key parameter in the spreadsheet, or protect parameters that are based on confidential or highly sensitive data. Awork-around is to hide formulas by saving documents in alternate formats, such as JPEG or HTML, which restricts access to formulas but prevents users from interacting with reports and performing simple what-if type scenarios. SharePoint 2007 addresses this issue by introducing Excel Services, a feature that enables spreadsheet collaboration in ways that are much more secure and robust than simple file sharing.

This chapter reviews the following:

After reading this chapter, you should feel comfortable with what Excel Services is and how it may benefit your organization. You should know the steps for creating your own reporting site for the sharing of business reports in a manner that makes important information available to users while still protecting any confidential details related to formulas or calculations.

Related

Категории