QueryTable Methods (Excel)

This object has the following methods:

Name

Description

CancelRefresh

Cancels all background queries for the specified query table. Use the Refreshing property to determine whether a background query is currently in progress.

Delete

Deletes the object.

Refresh

Updates an external data range (QueryTable).

ResetTimer

Resets the refresh timer for the specified query table or PivotTable report to the last interval you set using the RefreshPeriod property.

SaveAsODC

Saves the QueryTable cache source as an Microsoft Office Data Connection file.

Show:
© 2015 Microsoft