Drillthrough

Drillthrough is used to list the base data from the database that constitutes the cell on the spreadsheet.

The Drillthrough option is available on the right mouse button pop-up menu when:

• the currently active cell contains an XL3Lookup function
• the currently active cell is part of the data area of an active Grid

To display the Drill Through dialog, select a cell and choose XLCubed > Drillthrough... from the right mouse button menu.

• The Destination field determines where the Drillthrough information will be placed on the worksheet.
• The Limit Rows field allows you to restrict the returned result set.

The Drillthrough places the returned data directly onto the spreadsheet. The values inserted are values and not formulae.