Current Drill Path

You can activate the worksheets displayed in Current Drill Path.

To view a worksheet:

Click any worksheet listed under Current Drill Path to display it in Microsoft® Office Excel.

To rename a worksheet:

1. Highlight it then click Rename Sheet.
2. Specify a unique name, and click OK.

   The worksheet is renamed both in Current Drill Path window, and on the worksheet tab in Excel.

To delete a worksheet:

1. Highlight it then click Remove Sheet.

   A message appears warning you that All children sheets will be removed too.

2. Click Yes .

   The worksheet is deleted. If the worksheet has dependent, or child, worksheets, then these will also be deleted.

To save the current drill path:

Click Save Current Drill Path. The saved drill path is listed in Saved Drill Paths. You can save many different drill paths to the same workbook.

To clear the current drill path:

Click Clear Current Drill Path. The drill path is replaced by a drill path containing the workbook and worksheets you were previously viewing.

To add a new worksheet to the drill path:

Click Insert Worksheet in Excel.

To change the current drill path:

Save it before selecting a drill path in Saved Drill Paths to replay.