"Pivot table location" textbox (Resultset options dialog) |
|
Contains the address of the
cell where pivot table will be created in Excel. If a pivot is
already present SQL*XL will use the exising pivot table and attach the new results. The format of Excel cell addresses
as as follows:
A10 Cell A10 on the currently visible worksheet Sheet2!B2 Cell B2 on worksheet (tab) Sheet2 [Book1]Sheet3!D22 Cell D22 on worksheet (tab) Sheet3 in workbook (.xls file) Book1
Use the selector button to the right of this box to return to the sheet and to select a cell using the mouse and keyboard.
See also: