Microsoft Office Tutorials and References
In Depth Information
Excel Web Access
When you’re designing a web page, you can use the EWA settings to turn off some of the interactivity
From the Web Part menu, click Modify Shared Web Part to open the EWA tool pane. Scroll to the
Toolbar and Title Bar section to control the Refresh operations on the toolbar. You can uncheck the
Refresh Selected Connection, Refresh All Connections setting to remove the Refresh entries from the
Update toolbar. In addition, you can change the Type of Toolbar setting to remove some of the entries
from the toolbar, or to completely remove the toolbar. Figure 5-13 shows the EWA tool pane.
To disable pivot interactivity, scroll down to the Navigation and Interactivity section. You can uncheck
the Sorting, Filtering, or All Pivot Interactivity settings to disable some or all the PivotTable functionality.
The author can configure a workbook connection to automatically refresh at predefined time intervals.
On the server, this feature is mostly used for dashboards that constantly display the latest data from one
or more databases.