Return a result set to Microsoft Excel

Microsoft Query

Show All

Return a result set to Microsoft Excel

  1. If the Returning External Data to Microsoft Excel dialog box is not displayed, click Return Data , and if prompted, enter any parameter values required by the query.
  2. Click Properties to control formatting and layout options for how the external data range is brought into Microsoft Excel. For more information, see Microsoft Excel Help.
  3. To put the result set on the selected worksheet, click Existing worksheet. On your worksheet, click the cell where you want to place the upper-left corner of the result set, and then click OK.

    To put the result set on a new worksheet, click New worksheet, and then click OK. Microsoft Excel adds a new worksheet to your workbook and automatically puts the result set in the upper-left corner of the new worksheet.

    To use the external data in a PivotTable report, click PivotTable report, and then click OK.

Notes

  • The result set is automatically refreshed in Microsoft Query, before the Returning External Data to Microsoft Excel dialog box is displayed, even when the Auto Query button is not pressed in. If you want to prevent Query from running the query before you return the data to Excel, click Options on the Edit menu in Query, and then clear the Validate queries before saving or returning data check box.
  • You can check the status of a query that's taking a long time to return data. In Excel, click Refresh Status on the External Data toolbar. To cancel returning data, click Stop Refresh.