Hiding Worksheets

You can hide worksheets in a workbook. For example, you could hide a worksheet used to retrieve data from the Integrated Operational Planning database for use in a chart on a different worksheet. In Excel, hidden report worksheets are invisible to all users, including administrators.

  To hide a worksheet:

  1. In the Administration Workbench, go to the Presentation tab and select Worksheets.

  2. Select a worksheet.

  3. Click Visibility, and select Hide.

    Note:

    Hidden worksheets are not the same as private worksheets. Hidden worksheets are invisible to all users and are used to avoid displaying data that is not directly useful to users. Private worksheets restrict the view of data to prevent access by other users.