Show TOC

Delete Reports Locate this document in the navigation structure

You can delete one or more reports from a sheet.
Note Deleting rows or columns using standard Microsoft Excel commands does not delete a report from the worksheet.
To delete reports, select Start of the navigation path Report Actions Next navigation step Delete Reports End of the navigation path. The Delete Reports dialog box opens. In the Delete column, check the boxes corresponding to the reports you want to delete.
Note The first report created in the sheet is considered as the default report and it cannot be deleted.
The Delete Reports dialog box is composed as follows:
  • In the Default Report column, the default report is checked. You cannot modify this.
  • The Axis Shared By Reports column displays information when several reports share the same header in the sheet.
  • The Clear Report Cells option is selected by default. If you uncheck this option, the reports will still appear but they will be disconnected. For example, unchecking this option can be useful if you do not need to navigate in a report or refresh the data, but you still want to keep the data. This option enables you to keep the report as a simple copy in the sheet.