Saving a Workbook

Your options for saving a workbook depend on whether you have the privileges to save it to the database.

• If you are the owner of the workbook, and you have privileges to save it to the database, you can save the workbook and any changes to it.

• If you open a shared workbook you can use the Save As command to save the workbook under a different workbook name, if you have privileges to save workbooks to the database. However, if you don't have privileges to save workbooks to the database, you can view and edit the workbook but cannot save it. This precludes people without the proper privileges from overwriting someone else's workbook.

See your Discoverer Administrator to find out what type of privileges you have to save workbooks.

Click to learn how to:
To save a workbook:
To rename a worksheet:
To re-order worksheets in a workbook:

See also:
Editing a Worksheet
Creating a New Workbook
Refreshing Data in a Workbook
Deleting a Workbook


To save a workbook:

1. Choose one of the following:
   • Choose File | Save. The changes are saved and the workbook remains open.

   • To close and save a workbook at the same time, choose File | Close. If you haven't made changes to any worksheet in the workbook, it closes. If the workbook contains any unsaved changes on any worksheet, a dialog reminds you to save the changes.

   • To save the workbook under a new workbook name, choose File | Save As. The dialog appears for saving a workbook under a new name.

     
     

2. Enter a new name in the text box.

3. Click Save to save the changes

   Click Cancel to keep the workbook open without saving it.

   
   To rename a worksheet:
   1. Open the workbook that contains the sheet you want to rename.

   2. Do one of the following:

   • Double-click the tab at the bottom of the worksheet you want to rename.

   • From the menu, choose Sheet | Rename Sheet.
     
     The Rename Worksheet dialog appears.

   

   3. In the New name text field, type the new name for the worksheet.

   4. Click OK. The worksheet's new name appears on its tab, which is located on the bottom of the worksheet.

      
      To re-order worksheets in a workbook:

   1. Open the workbook that contains the worksheets you want to re-order.

   2. From the menu, choose Sheet | Move Sheet.
      
      The Move Worksheets dialog appears.

   

   3. Click on the name of a worksheet and then click the up arrow or down arrow. The worksheet moves up or down to a different position.

   4. Repeat step 3 for every worksheet you want to re-order.

   5. When you are finished, click OK.