Summary

In this chapter, we have examined the new Business Intelligence capabilities available in SharePoint Server 2007 through Excel Services. We began with a discussion of how to configure Excel Services on servers where Office SharePoint Server 2007 has already been installed. We identified the basic steps required to enable Excel Services and to configure a Trusted File Location, which will allow workbooks to be processed on the server. Next we reviewed the roles of the major components of Excel Services—including Excel Calculation Services, Excel Web Access, Excel Web Services, and the Excel Calculation Service Proxy. We then explained how to publish workbooks through the Publish command in Excel 2007, including how to hide sheets and define ...

Get Microsoft® Office SharePoint® Server 2007 Administrator's Companion 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.