Skip to main content

Active Sheet (Excel)

Use Active Sheet to work with OfficeReports content in the selected worksheet. You can copy the worksheet, apply one filter to all OfficeReports content in the worksheet, or refresh the worksheet.

Active Sheet in the OfficeReports Ribbon tab

This video shows the Active Sheet functionality

Copy Sheet​

Use Copy Sheet to copy a worksheet and keep all OfficeReports settings for tables, charts, and verbatim lists in the worksheet.

This is useful when you want to duplicate a worksheet that contains many tables and use different filters in the copy.

Filter Sheet​

Use Filter Sheet when you want to apply the same filter to all tables, charts, and verbatim lists in one worksheet.

Note: The new filter setting overrides any individual filter already defined for the tables, charts, or verbatim lists in the worksheet.

Refresh Sheet​

Use Refresh Sheet to refresh all OfficeReports content in the selected worksheet.

This works the same way as Refresh Report, but only for the current worksheet.