QueryTable XML

<queryTable xmlns="…" name="Text" refreshOnLoad="1" fillFormulas="1"
  removeDataOnSave="1" connectionId="3" autoFormatId="16" 
  applyNumberFormats="0" applyBorderFormats="0" applyFontFormats="1" 
  applyPatternFormats="1" applyAlignmentFormats="0" 
  applyWidthHeightFormats="0"/>

In the context of <queryTable>:

• @refreshOnLoad value of 1 indicates that this QueryTable should be refreshed when the workbook is opened.

• @fillFormulas indicates that this QueryTable has immediately adjacent columns (which are not part of the QueryTable range) containing formulas that need to be filled down as the QueryTable grows and shrinks in size after refresh.

• @removeDataOnSave indicates that the data in the worksheet resulting from the QueryTable refresh should be removed from the worksheet when saved and closed.