What is the difference between Workbook Filters and Worksheet Filters?
In OfficeConnect there are two different filtering options - Workbook Filters and Worksheet Filters
- Workbook Filters: Filters applied in Workbook Properties will be applied to all current and future sheets within the report. Users must navigate to the Workbook Properties to edit these.
- Worksheet Filters: Filters can also be applied from the Worksheet, and will only apply to the Worksheet they were set on.
To learn more about filtering in OfficeConnect, watch the video below.