FillAdjacentFormulas True if formulas to the right of the query table are automatically
updated whenever the query table is refreshed.
PreserveFormatting True if formatting common to the first five rows of data are applied
to new rows in the query table.
RefreshOnFileOpen True if the PivotTable cache or query table is automatically updated
whenever the workbook is opened.
BackgroundQuery True if queries for the query table are performed in the background.
RefreshStyle Returns/sets the way rows on the specified worksheet are added or
deleted to accommodate the number of rows in a recordset
(returned by a query).
Continued
CHAPTER 2 n DATA IN, DATA OUT 45
Table 2-1. Continued
QueryTable Object Members Description
SavePassword True if password information in an ODBC connection string is saved
with the query. False if the password is removed.
SaveData True if data for the query table report is saved with the workbook.
False if the report definition is saved and nothing else.
AdjustColumnWidth True if the column widths are automatically adjusted for the best fit
each time you refresh the specified query table. False if they are not.
RefreshPeriod Returns/sets the number of minutes between refreshes.
PreserveColumnInfo True if column sorting, filtering, and layout information is preserved
when a query table is refreshed. Default value is False.
SourceDataFile Returns/sets a String value that indicates the source data file for a
query table.
ListObject.
Pages:
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73