Defining Data Formatting and Layout
The report layout determines how the data returned from
the server interacts with the existing worksheet and any existing
content in the worksheet. The following list contains some options
that you can select in the Data formatting and layout section of
the External Data Range Properties dialog box.
-
Preserve cell formatting. Affects the way in which
data is returned to the worksheet when it is refreshed. If this
check box is selected, the existing formatting in the worksheet
is preserved. If this check box is clear, the existing formatting
is removed when the query is refreshed. This check box is selected
by default.
-
If the number of rows in the data range change upon refresh. Determine how
existing data is handled when new data is returned from a query.
In some instances, the number of rows returned from the query may
be more or less than the original data set. The following options
determine what happens when this occurs.
- Insert cells for
new data, delete unused cells.
- Insert entire rows for new data, clear unused cells.
- Overwrite existing cells with new data, clear unused cells.
For more information on specifying external data range properties
for a query, see your Microsoft Excel documentation.