Designating the Location of Query Results

After you select a format for the worksheet, use the Workbook tab to define where the query results should go.

There are two options for the location of query results. You can:

  • Display the data in a workbook you currently have open.

  • Display the data in a saved workbook.

You can define the sheet number, starting column, and starting row for the selected workbook. You can also clear data from the selected worksheet before generating a new one.

Note: If you choose to save the data into a workbook and/or worksheet within a workbook, those items must already have been saved in Excel prior to clicking Finish. If they have not been saved, Add-ins creates a new workbook.

Also remember that when data is returned, you must save the workbook again—Add-ins does not save any files or data. When naming the Excel file or spreadsheets within the workbook, do not use hyphens or spaces. Doing so may cause problems with Excel.