Microsoft Office Tutorials and References
In Depth Information
Excel Web Access
After you open a workbook with external data, you can refresh it and perform interactivity.
From the Update entry in the EWA toolbar, you can refresh all data connections in the workbook or only
a selected connection. To refresh only one connection, select it by clicking anywhere within the data range
and choose Refresh Selected Connection from the toolbar. Figure 5-11 shows the Refresh entries on the
In Excel Services, you can perform the following operations on the rows, columns, and filter fields of a
PivotTable (see Figure 5-12):
Press the plus (+) and minus (-) controls to expand and collapse members in a hierarchy.
Sort in ascending or descending order.
Filter the labels or values by selecting from a list of members, or by choosing from a list of
options (such as equals, less than, greater than, and between).