Excel Services
Encyclopedia
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 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 which 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 part
s) together.
However, Excel Services cannot be used to create workbooks. To author a workbook, a user must use Microsoft Office Excel 2007.
Microsoft Excel
Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications...
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
Web portal
A web portal or links page is a web site that functions as a point of access to information in the World Wide Web. A portal presents information from diverse sources in a unified way....
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
End-user
Economics and commerce define an end user as the person who uses a product. The end user or consumer may differ from the person who purchases the product...
s can view live, interactive workbooks using only a web browser
Web browser
A web browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by a Uniform Resource Identifier and may be a web page, image, video, or other piece of content...
. They can also interact with workbooks to explore data, and analyze Pivot Table
Pivot table
In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet...
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 which 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
Web part
A Web Part, also called a Web Widget, is an ASP.NET server control which is added to a Web Part Zone on Web Part Pages by users at run time. The controls enable end users to modify the content, appearance, and behavior of Web pages directly from a browser...
to filter several Web Parts (Excel Web Access and other types of web part
Web part
A Web Part, also called a Web Widget, is an ASP.NET server control which is added to a Web Part Zone on Web Part Pages by users at run time. The controls enable end users to modify the content, appearance, and behavior of Web pages directly from a browser...
s) together.
However, Excel Services cannot be used to create workbooks. To author a workbook, a user must use Microsoft Office Excel 2007.