How to save worksheets

If you have made changes to a worksheet (e.g. you have re-sorted data or repositioned worksheet items), you can save these changes. If you are logged in to Discoverer as the owner of the workbook that contains the worksheet, you can overwrite the original worksheet. If you are not logged in as the owner of the workbook that contains the worksheet, you can save a copy of the worksheet.

If you change a worksheet and then switch to a different worksheet, Discoverer prompts you to save the changes you have made or discard the changes.

To save a worksheet:

1. Display the worksheet that you want to save.

   If you own the worksheet, both the Save and Save As options are available. If you do not own the worksheet, only the Save As option is available.

2. Save the worksheet as follows:

   If you own the worksheet, do one of the following:

   • to save changes to the worksheet, select the Save link

   • to save the worksheet in a workbook with a different workbook name, select the Save As link to display the Save Workbook As page and specify a new workbook name

   If you do not own the worksheet, to save the worksheet in a workbook as a different workbook name, select the Save As link to display the Save Workbook As page and specify a new workbook name.

Discoverer saves the worksheet in the database in the current workbook. If you use the Save As option, workbooks are always stored in the root folder.