Using Excel Services
Excel Services is a new shared service of Microsoft Office SharePoint Server 2007. Excel Services enables you to load, calculate, and display Excel workbooks on Office SharePoint Server 2007. Excel Services is designed to be a scalable, robust, enterprise-class server that provides feature and calculation fidelity with Microsoft Office Excel 2007.
Using Excel Services you can easily reuse and share Excel workbooks on portals and dashboards on Office SharePoint Server 2007. For example, financial analysts, business planners, or engineers can create content in Excel and share it with others by using an Office SharePoint Server 2007 portal and dashboard. This can be done without writing custom code. You can also control which data is displayed, and you can maintain a single version of the workbook.
There are two primary interfaces for Excel Services:
An Excel Web Access Web Part, which enables you to view and interact with a live workbook using a browser
Excel Web Services for programmatic access
In addition, you can extend the third component of Excel Services, called Excel Calculation Services, with user-defined functions (UDFs).
Using Excel Services, you can view live, interactive workbooks with only a browser. This means you can save Excel workbooks and interact with them from within portal sites. You can also interact with workbooks to explore and pivot on data, and you can analyze PivotTable reports and charts using a browser.
Excel Services supports workbooks that are connected to external data sources. You can embed connection strings to external data sources in the workbook, or you can save them centrally in a data connection library file.
You can find more information about Excel Services in the section titled Creating Custom Solutions with Excel Services.