2.1.853 Part 4 Section 3.12.2, queryTable (Query Table)
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.