Skip to content

Latest commit

 

History

History
39 lines (22 loc) · 1.27 KB

Excel.QueryTable.BackgroundQuery.md

File metadata and controls

39 lines (22 loc) · 1.27 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
QueryTable.BackgroundQuery property (Excel)
vbaxl10.chm518081
vbaxl10.chm518081
Excel.QueryTable.BackgroundQuery
d3fd1d37-4956-7fda-accc-25eedf5188c0
05/03/2019
medium

QueryTable.BackgroundQuery property (Excel)

True if queries for the query table are performed asynchronously (in the background). Read/write Boolean.

Syntax

expression.BackgroundQuery

expression A variable that represents a QueryTable object.

Remarks

For OLAP data sources, this property is read-only and always returns False.

If you import data by using the user interface, data from a web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.

If you import data by using the object model, data from a web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.

Use the QueryTable property of the ListObject to access the BackgroundQuery property.

[!includeSupport and feedback]