O'Reilly logo

SharePoint 2010 All-in-One For Dummies by Veli-Matti Vanamo, Kevin Laahs, Emer McKenna

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required