Excel Services

Excel Services is a server technology included in SharePoint 2007 and 2010 that enables users to load, calculate, and display Excel 2010 workbooks on SharePoint 2010.

Using Excel Services, users can reuse and share Excel workbooks on Microsoft Office SharePoint Server 2007 portals and dashboards. For example, they can create content in Excel 2007 and share it by using an Office SharePoint Server 2007 portal and dashboard. The entire workbook or just parts of it (such as just a single sheet, chart, or table) can be shared.

End users can view live, interactive workbooks using only a web browser. They can also interact with workbooks to explore data and analyze Pivot Table reports and charts by using a browser. Excel Services supports workbooks that are connected to external data sources. Users can embed connection strings to external data sources in the workbook or save them centrally in a data connection library file.

Selected cells in worksheets can be made editable by making them named ranges or "parameters". Items that are set as "viewable", when they save to Excel Services, will appear in the Parameters pane in the browser. Users can change the values of these named ranges in the parameters pane and refresh the workbook. They can also use the portal's filter Web Part to filter several Web Parts (Excel Web Access and other types of web parts) together.

However, Excel Services cannot be used to create workbooks. To author a workbook, a user must use Microsoft Office Excel 2007.

External links

• Excel Services at Wikipedia
• Official website

References

• Asnash et al. (2007). Beginning Excel Services. Wiley. ISBN 0-47-010489-9
• Prish, S. (2007). Professional Excel Services. Wiley. ISBN 0-47-010486-4