Chapter 4: Working with Excel Services
In This Chapter
Creating your Excel Workbooks
Publishing your Excel Workbooks to Excel Services
Modifying with workbooks in Edit mode
Getting handy with the Excel Web Access Web Part
Working with Excel Web App
Even the standard capabilities of Microsoft Excel 2010 can make your data come to life. For example, you can create PivotTables and PivotCharts to provide a graphical summary of your business data that you can filter according to your needs. Features such as Visual Slicers (new with Excel 2010) offer easy ways to filter the data in your PivotTables and PivotCharts. Excel Services understands these new Excel 2010 capabilities, and takes them into account when you publish a workbook to SharePoint: What you see through the browser looks and feels just like the Excel client application. If you want to have that same high-fidelity viewing experience when you’re editing Excel workbooks through the browser, you can install Office Web Apps in your server farm — and edit your workbooks to your heart’s content, using the Excel Web App functionality.
Workbooks that you publish to Excel Services immediately inherit all the capabilities of the SharePoint environment. For example, if you’ve enabled versioning in the document library to which you publish your workbook, then SharePoint keeps track of the versions of your workbook. You can roll back to a previous version if necessary, and workbooks published to Excel Services are available for use ...