As an administrator, you can view details for planning, report, and data collection worksheets that are registered in Integrated Operational Planning. Registered worksheets are available for use in planning, report, and data collection workbooks.
Each worksheet belongs to an Excel workbook. The file name of a registered worksheet is given by the file name of the Excel workbook that contains it. An Excel workbook can contain other worksheets.
To view details for registered planning, report, and data collection worksheets:
In the Administration Workbench, go to the Presentation tab and select Worksheets.
Excel Sheet—Name of the Excel worksheet. Select a name to open the worksheet in Excel.
Modified—Whether the worksheet has been modified since it was created.
Private—Whether the worksheet is public or private. Only the worksheet owner and the administrator can view private worksheets. All users can view public worksheets.
Hidden—Whether the worksheet is hidden
See Hiding Worksheets.
Dependents—Whether the worksheet is dependent on another worksheet. For example, a report worksheet may depend on data in a hidden worksheet. Or a Refresh Data button in one worksheet may also refresh data in another worksheet.
In Excel, you cannot insert a dependent worksheet into a planning workbook. On the Presentation tab, you can add a dependent worksheet to a workbook, but you must also add the worksheets on which it depends. Otherwise, problems may occur when the workbook is used in scenarios.