Microsoft Office Tutorials and References
In Depth Information
Interactivity and Char ting
Continue viewing and analyzing the workbook offline.
Print the workbook. (Excel’s printing capabilities are superior to printing from the browser.)
Further change and analyze the workbook using features only available in the client (such as
creating new charts, inserting additional fields in a PivotTable, and authoring new calculations).
When you choose to open a workbook from the EWA toolbar, you are not opening the original
workbook file that was opened by the server. Instead, you are opening the current workbook as it exists in the
server’s memory. This means that any changes that were made to the workbook, either by refreshing
external data or through user interaction (such as filtering a table), are reflected in the workbook you see
in Excel client. It also means that if you choose to save the workbook from the client, by default you do
not save over the original workbook file.
Opening workbooks in Excel client only works with Excel 2007. Even if you have the compatibility pack
installed on previous versions of Excel, you cannot open the file within Excel. This is also true for
opening workbook snapshots.
Using the Toolbar to Calculate a Workbook
So far, the exercises in this topic assumed that you are publishing the workbook with the calculation
mode set to Automatic. This is the default mode on the client. There are cases in which publishing a
workbook in Manual calculation mode makes sense. For these cases, you can trigger a workbook
calculation using the Calculate option on the toolbar. This is similar to clicking the Calculate button on the
Ribbon in the client, or pressing the F9 key. The Calculate button on the toolbar in EWA calculates all the
sheets in the workbook.
Assume you have a workbook that takes a significant time to calculate, and it contains both volatile data
and input parameters. In this case, you would not want the workbook to calculate each time you open it
in the browser and have to wait for the calculation to complete. Rather, you would want to give the user
control to set the parameters first and then calculate the workbook. To do this, you set the workbook to
Manual calculation mode in the client and publish it to the server. When the user opens the workbook
in the browser, it does not calculate. The user can set the parameters in the workbook and then calculate
the workbook using the Calculate option on the toolbar.
In the following Try It Out, you change the calculation mode for the example workbook to Manual and
publish it to the server in this state. You then change the workbook parameters to verify that it does not
calculate and update. Finally, you use the toolbar to manually trigger a calculation of the workbook and
update the results.
Try It Out Manually Triggering a Workbook Calculation
To manually trigger a workbook calculation, follow these steps:
Open the original Sales Report.xlsx workbook in Excel client.
Switch to the Formulas tab on the Ribbon.
Select the Calculation Optons drop-down menu.
Change the calculation mode to Manual, as shown in Figure 10-18.