Microsoft Office Tutorials and References
In Depth Information
Excel Web Access
As opposed to PivotTables, Excel Services does not have this performance optimization for OLAP
formulas. The ECS issues the OLAP formulas queries synchronously during the calculation of other workbook
formulas.
Excel Web Access
In the previous sections, you learned about external data and focused mainly on the ECS and the
administrator’s experience. This section looks at the Excel Web Access (EWA) and the end user’s experience.
External data queries may occur when the user opens the workbook, explicitly when the user refreshes
the data or interacts with a PivotTable, and implicitly as part of periodic refresh. The following sections
examine each of these cases.
Refresh on Open
When opening a workbook with refresh on open, the data will refresh automatically. The user might get
a message asking for confirmation to perform the data query, as shown in Figure 5-10.
Figure 5-10
Search JabSto ::




Custom Search