Best Practices

• Excel Services allows Excel 2010 users to publish components of a workbook to a SharePoint library, and then the Excel Web Access web part can be used to connect to a published Excel workbook and display tables, charts, and other items in the web part, typically on a read-only basis.

• Many users want to interact with the data presented by Excel Web Access web part, so the different tools available from the File tab in the Excel Web Access web part (Open in Excel, Download a Snapshot, Download a Copy) should be demonstrated to users. In addition, the section in this chapter titled, “Allowing Parameter Input in Excel Web Access,” shows how a cell can be named and then published via Excel Services to allow input to the Excel ...

Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.