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.