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.