QueryTable Methods (Excel)
.png "GitHub-Mark-64px") |
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Methods
Name |
Description |
|---|---|
Cancels all background queries for the specified query table. Use the Refreshing property to determine whether a background query is currently in progress. |
|
Deletes the object. |
|
Updates an external data range (QueryTable). |
|
Resets the refresh timer for the specified query table or PivotTable report to the last interval you set using the RefreshPeriod property. |
|
Saves the QueryTable cache source as an Microsoft Office Data Connection file. |