Active Sheet (Excel)

Active Sheet in the OfficeReports Ribbon tab

This video shows the Active Sheet functionality

Copy Sheet

When copying a worksheet, using the OfficeReports feature in the menu, all OfficeReports settings for tables, charts and text lists in the worksheet are saved.

This is a nice feature, for example if you have many tables on a sheet which you want to duplicate with different filters..

Filter Sheet

If you need the same filter for all tables/charts/texts list in one worksheet, this feature can be useful.

Note: The new filter setting will overrule any individual filter that has already been defined for the tables/charts/text list in the worksheet.

Refresh Sheet

Refreshes all OfficeReports content in the selected sheet, just like 'Refresh Report' does for the complete workbook.