www.microsoft.com/office/excel
27
Creating a “snapshot” of a spreadsheet.
Users can now manage spreadsheets
by using “snapshots.” Snapshots have the look of the original spreadsheet, but
contain only the values and formatting from that spreadsheet. Other proprietary
or sensitive data (such as formulas, hidden cells, or document properties) are not
available within snapshots. Snapshots allow you to share information with
customers and business partners more securely—reducing concern about exposing
sensitive data. They are also an ideal way for analysts to create historical views of
reports for data comparisons and identifying trends.
View Item Right.
One of the most important features in Office SharePoint Server
2007 is the View Item Right. This right restricts a user to executing a file on the
server or gaining access to a snapshot of the values in the visible portions of a
spreadsheet. The spreadsheet file in its entirety cannot be downloaded and
opened on a client computer. By using the Report Library in Office SharePoint
Server 2007, administrators can control who has access to the intellectual
property, such as formulas and external data sources within a workbook, while
still allowing users to view and interact with the data through a Web browser and
in Office Excel 2007.
Publish to Office SharePoint Server 2007
Office Excel 2007 works with Excel Services and Office SharePoint Server 2007 to provide
important benefits that extend beyond simply saving a file to a SharePoint document
library.
Publish to "trusted" locations.
Excel Services only renders files that are stored
in administrator-configured folders. Excel communicates with Office SharePoint
Server 2007 to publish a list of these locations specified by the IT administrator.
Publish specific pieces of a spreadsheet.
When you publish a document to
Office SharePoint Server 2007, you can control whether the viewer sees an entire
spreadsheet, specific sheets within a spreadsheet, or charts, tables, PivotTable
views, and Named Ranges within a spreadsheet.
Summary of Contents for 065-04940 - Office Excel 2007
Page 1: ...Microsoft Office Excel 2007 September 2006...
Page 15: ...www microsoft com office excel 12 predefined styles to any spreadsheet...
Page 19: ...www microsoft com office excel 16 Figure 27 Enhanced filtering and sorting...
Page 24: ...www microsoft com office excel 21 Figure 29 Integration with SQL Server 2005 Analysis Services...
