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
.
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.