Choose Worksheet dialog

Use this dialog to choose a worksheet to display to when you are creating a drill link to a worksheet. For example, to create a drill link from a worksheet item to a worksheet called Sales Details, you use this dialog to select the Sales Details worksheet.

For more information, see:

"What are worksheets?"

"About user defined drill links"

View

Use this list to specify the type of workbooks you want to display in the Workbooks list. For example, you might choose My Workbooks to display only workbooks owned by the database user that you are logged in as.

<View as button>

Use this drop down list to select how to view the Workbooks list. For example, you might choose the User Tree option to display workbooks grouped by database user.

Name contains

Use this field to restrict the Workbooks list to those workbooks with names that contain the character(s) that you specify. For example, enter 'January' to display only those workbooks with names that contain January in the Workbooks list.

Clear

Use this button to clear any text in the Name contains field and display the names of all workbooks in the Workbooks list.

Workbooks

Use this list to select the workbook and worksheet you want to display when a drill link is selected. First select a workbook (represented by a book icon). To display worksheets in a workbook, click the + icon next to the workbook. Select a worksheet in a workbook to create a drill link to that worksheet.

Hint: Click on a column name to sort the Workbooks list on that column. Click on the arrow in a column name to reverse the sort order. You can also re-position and re-size the columns.

Description

This field displays additional information about the workbook, which was entered using the "Workbook Properties dialog". Use this information to help you decide which workbook you want to analyze. This area is blank if no description is available.

Hint: To add or edit the description, update the workbook's properties (for more information, see "How to view and update a workbook's properties").

Select

Use this button to create a drill link to the worksheet currently selected in the Workbooks list.