- Excel Services
Excel Services is a new server technology included in
Microsoft Office SharePoint Server 2007 . This shared service enables users to load, calculate, and display Excel 2007 workbooks on Microsoft Office SharePoint Server 2007.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 user s can view live, interactive workbooks using only aweb browser . They can also interact with workbooks to explore data, and analyzePivot 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". These items that users choose to make 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 part s) together.However, Excel Services cannot be used to create workbooks. To author a workbook, user must use Microsoft Office Excel 2007.
ee also
*
Comparison of office suites External links
* [http://office.microsoft.com/en-us/sharepointserver/HA101054761033.aspx Official website]
* [http://sharepointmagazine.net SharePoint Magazine]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
Wikimedia Foundation. 2010.
