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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access