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.

For more information on specifying external data range properties for a query, see your Microsoft Excel documentation.