Excel Services is a server technology included in
SharePoint 2010
SharePoint is a web-based Collaborative software, collaborative platform that integrates natively with Microsoft Office. Launched in 2001, SharePoint is primarily sold as a document management and storage system, but the product is highly confi ...
and
SharePoint 2007
SharePoint is a web-based collaborative platform that integrates natively with Microsoft Office. Launched in 2001, SharePoint is primarily sold as a document management and storage system, but the product is highly configurable and its usage v ...
. This shared service enables users to load, calculate, and display
Excel
ExCeL London (an abbreviation for Exhibition Centre London) is an exhibition centre, international convention centre and former hospital in the Custom House area of Newham, East London. It is situated on a site on the northern quay of the Ro ...
2010 workbooks on Microsoft Office SharePoint Server 2010.
Using Excel Services, users can reuse and share Excel workbooks on Microsoft Office SharePoint Server 2010
portals
Portal often refers to:
*Portal (architecture), an opening in a wall of a building, gate or fortification, or the extremities (ends) of a tunnel
Portal may also refer to:
Arts and entertainment Gaming
* ''Portal'' (series), two video games ...
and dashboards. For example, they can create content in Excel 2010 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
In product development, an end user (sometimes end-user) is a person who ultimately uses or is intended to ultimately use a product. The end user stands in contrast to users who support or maintain the product, such as sysops, system administrato ...
s can view live, interactive workbooks using only a
web browser
A web browser is application software for accessing websites. When a user requests a web page from a particular website, the browser retrieves its files from a web server and then displays the page on the user's screen. Browsers are used on ...
. They can also interact with workbooks to explore data, and analyze
Pivot Table
A pivot table is a table of grouped values that aggregates the individual items of a more extensive table (such as from a database, spreadsheet, or business intelligence program) within one or more discrete categories. This summary might include ...
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 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 ...
to filter several Web Parts (Excel Web Access and other types of
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 ...
s) together.
References
* Asnash et al. (2007). ''Beginning Excel Services''. Wiley.
* Prish, S. (2007). ''Professional Excel Services''. Wiley.
External links
Official Excel Services 2007 websiteOfficial Excel Services 2010 website
Excel Services Excel Services is a server technology included in SharePoint 2010 and SharePoint 2007. This shared service enables users to load, calculate, and display Microsoft Excel, Excel 2010 workbooks on Microsoft Office SharePoint Server 2010.
Using Excel S ...
Spreadsheet software
SharePoint
{{Windows-software-stub