O'Reilly logo

Microsoft SharePoint 2010 Unleashed by Michael Noel, Colin Spence

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

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

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