Microsoft Office Tutorials and References
In Depth Information
Working with Workbook Parameters
How It Works
When you entered 20% for the Forecast parameter and clicked Apply, Excel Services changed the value
for the cell named Forecast in the workbook. Because the workbook is in automatic calculation mode,
this triggered a calculation of the values in the sales forecast.
If you were publishing the workbook to display in Named Item mode, you would not even see the
Forecast cell. You can use this mode to keep all of your parameters on a separate sheet in the workbook
and not make that sheet visible on the server. This simplifies the experience for the user.