Configuring Excel Services
Excel Services is an application service configured at the farm level and then made available to sites in the SharePoint environment. Excel Services enables you to interact with Excel workbooks in the browser. There are three main components to Excel Services:
- Excel Calculation Services: Responsible for carrying out calculations on the workbook.
- Excel Web Access: Displays your Excel workbooks within the browser.
- Excel Web Services: Provides access to the Excel Services application via code and web services.
Note that even if you are using Excel Services, your workbook will not be fully editable nor will you be able to create new workbooks using the browser. If you require these features, you have to install Office Web Applications in addition to SharePoint.
Before you can take advantage of Excel Services, you need to get your Excel documents to the SharePoint server. Publishing to Excel Services is as simple as saving your workbook to a document library and then opening it in the browser. Generally, with documents like this, you should set the default behavior for opening documents in the library to open web-enabled applications in the browser using the document context menu. The user can then, if required, continue working on the document by opening it in the Excel client.
One of the differences between SharePoint 2007 and SharePoint 2010 ...