Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Dialogs Resultset Options

Buy now

Download now

SQL*XL online help

SQL*XL: Resultset Options dialog: Pivot table location textbox

"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:

SQL*XL ribbon in Excel