Microsoft Office Tutorials and References
In Depth Information
Interactivity and Char ting
Open the Publish To Excel Services dialog box.
Click the Excel Services Options button to bring up the relevant dialog box.
Switch to the Parameters tab.
Click the Add button.
Select Forecast by checking the box next to it and clicking OK.
Click OK to exit the Excel Services Options dialog box.
Click the Save button to publish the workbook. Ensure that you have the Open In Excel Services
option selected so that the browser opens with the workbook displayed.
View the workbook in the browser and switch to the Sales By Reseller Type sheet.
In the Parameter task pane, change the value for Forecast to 20% and click Apply. The values
for Q4/06 do not change, because the workbook is in Manual calculation mode.
Open the Update menu and select Calculate Workbook. The values in column Q4/06 are
updated, because the workbook is calculated with the new parameter.