2.1.826 Part 1 Section 18.12.2, queryTable (Query Table)
-
For additional notes that apply to this portion of the standard, please see the notes for pivotTableDefinition, §18.10.1.73(s-y); raf, §18.11.1.8(b).
a. The standard does not state any limitations on the value of @firstBackgroundRefresh.
-
Office requires that if @firstBackgroundRefresh is true, then @backgroundRefresh shall also be true.
b. The standard does not state that @name must be unique.
-
Office requires that @name be unique.
c. The standard does not state any limitations for @connectionId.
-
Office requires @connectionId to be greater than 0 and must refer to a valid external data connection.
d. The standard does not define any relationship between @name and defined names.
-
In Office, if there is a definedName that matches this value, with any spaces within this name converted to underscores (“_”) for the purposes of this comparison, then that definedName indicates the range of this query table.
e. The standard does not state any limitations on the value of @removeDataOnSave.
-
Office ignores @removeDataOnSave if @refreshOnLoad is false.
f. The standard does not place restrictions on the length of @name.
-
Office requires that @name be less than 256 characters in length, and non-empty.
g. The standard does not define any relationship between @name and tables.
-
In Office, if this query table is related to a Table, then a definedName associated with this @name shall exist and shall refer to the same range the Table refers to.