How to rename worksheets and workbooks

You rename a workbook to change its name used in Discoverer. For example, you might want to create a more meaningful workbook name by changing a workbook name from My Workbook to Sales Reports.

You rename a worksheet when you want to change the name displayed in the worksheet tab. For example, you might want to change the default worksheet name created by Discoverer (e.g. Sheet 2) to something more meaningful (e.g. Sales Report).

To rename a workbook:

1. If it is not already open, open the workbook that you want to rename (for more information, see "How to open workbooks").

2. Choose File | Save As to display the "Save Workbook to Database dialog" and enter a new name in the New Name field.

   Note: Do not include a colon (:) character.

3. Click Save to save the workbook.

4. (optional) Delete the original workbook (for more information, see "How to delete workbooks from the database").

   The workbook's new name is displayed at the top of the Discoverer work area.

To rename a worksheet:

1. If it is not already open, open the workbook that contains the worksheet you want to rename and display the worksheet.

2. Choose Edit | Worksheet Properties to display the "Worksheet Properties dialog: General tab".

   Note: You can also display the worksheet properties dialog by double-clicking the worksheet name tab at the bottom of the worksheet.

3. Enter the new name for the worksheet in the Name field.

4. Click OK to rename the worksheet.

   The worksheet's new name is displayed at the bottom of the worksheet.