QueryTable Methods
Include Protected Members
Include Inherited Members
The QueryTable type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
add_AfterRefresh | Reserved for internal use. (Inherited from RefreshEvents_Event.) |
|
add_BeforeRefresh | Reserved for internal use. (Inherited from RefreshEvents_Event.) |
|
CancelRefresh | Cancels all background queries for the specified query table. Use the Refreshing property to determine whether a background query is currently in progress. (Inherited from _QueryTable.) |
|
Delete | Deletes the object. (Inherited from _QueryTable.) |
|
Refresh | Updates an external data range (QueryTable). Boolean. (Inherited from _QueryTable.) |
|
remove_AfterRefresh | Reserved for internal use. (Inherited from RefreshEvents_Event.) |
|
remove_BeforeRefresh | Reserved for internal use. (Inherited from RefreshEvents_Event.) |
|
ResetTimer | Resets the refresh timer for the specified query table or PivotTable report to the last interval you set using the RefreshPeriod property. (Inherited from _QueryTable.) |
|
SaveAsODC | Saves the PivotTable cache source as a Microsoft Office Data Connection file. (Inherited from _QueryTable.) |
Top