Allowing Parameter Input in Excel Web Access

Another feature to be familiar with is the ability to name a cell in Excel 2010, publish it using Excel Services, and users will then be able to input a value through the Excel Web Access interface. Although somewhat time-consuming to configure, it can allow for interactivity through the Excel Web Access web part that might be very useful for encouraging end users to interact with the data. Bear in mind that any data input by end users in the Excel Web Access web part is not saved to the published spreadsheet, so is really only for “what if” scenarios.

The following example reflects a situation where an IT manager wants to show senior management the impact of total number of help desk resources on ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.