How to use drill links

You use drill links that you set up yourself (or are set up by the worksheet creator) to drill out to other worksheets or Internet pages. You can also drill out to a file stored in the database. For more information, see "About user defined drill links".

You can drill to another worksheet, Internet URL, or file stored in the database using:

• a drill link icon (for more information, see "How to drill out to a worksheet or Internet URL using a drill link icon")

• the Drill dialog (for more information, see "How to drill out to a worksheet or Internet URL using the Drill dialog")

How to drill out to a worksheet or Internet URL using a drill link icon

You drill out to analyze data or information external to the current worksheet. For example, you might want to:

• display a different worksheet in a new tab window

• display an Internet page in a browser window

• display a file (e.g. a Microsoft Word file) in a separate application

To drill out to a worksheet, Internet page, or file:

1. Select the drill link icon in the worksheet cell you want to drill out from.

   
   Description of the illustration ddrill24.gif
   
   

   Discoverer displays a pop up list of drill links available. Select the link that you want to use from the pop up list.

   
   Description of the illustration drill16.gif
   
   

Discoverer behaves as follows:

• if you drill out to a worksheet in the same workbook, Discoverer displays the worksheet in a new tab window

• if you drill out to a worksheet in a different workbook, Discoverer closes the current workbook and opens the new workbook and worksheet

• if you drill out to an Internet page, Discoverer displays the Internet page in a new browser window

• if you drill out to a file, Discoverer displays the file using associated application (e.g. a text editor)

How to drill out to a worksheet or Internet URL using the Drill dialog

To drill out to a worksheet or Internet URL using the Drill dialog:

1. Select the worksheet item or cell you want to drill on.

   
   Description of the illustration drill17.gif
   
   

2. Choose Tools | Drill to display the "Drill dialog".

   
   Description of the illustration ddrill18.gif
   
   

   Hint: You can also display the Drill dialog by right-clicking on a worksheet cell and selecting the Drill option.

3. If you did not select a worksheet cell in step 1, use the Where do you want to drill from? drop down list to select the worksheet item you want to drill on.

4. Select Drill to Link from the Where do you want to drill to? drop down list.

   
   Description of the illustration drill18.gif
   
   

5. Select an item from the list.

6. Click OK.

   Discoverer behaves as follows:

   • if you drill out to a worksheet in the same workbook, Discoverer displays the worksheet in a new tab window

   • if you drill out to a worksheet in a different workbook, Discoverer closes the current workbook and opens the new workbook and worksheet

   • if you drill out to an Internet URL, Discoverer displays the Internet page in a new browser window