Workbook Slicers

As of Version 8 you can create slicers at the workbook level which can be displayed for all sheets in a workbook.

These slicers are displayed in a slicers pane which can be arranged vertically or horizontally. The slicer pane stays in place when the sheet is changed, meaning that in a multi-sheet workbook you need now only define one set of slicers, which you can then configure to show or hide for individual sheets as needed.

Turning on the pane

The workbook slicer pane can be turned on in Excel using the Slicer > Workbook Slicers ribbon item

On the web there is a toolbar button to toggle the pane, which is enabled if the current report has workbook slicers available.

Configuring Slicers

Within the slicer pane the Add Slicer button brings up the standard slicer design forms, so from here you create the workbook slicers in the same way was you would the existing sheet based slicers. The image below shows the slicer pane.

The Edit Layout button allows you to configure the slicer order and the padding between individual slicers. It also allows slicers be visible or hidden on specific sheets. For example you may wish to hide a slicer for a particular sheet where it does not apply.

To size slicers right click the slicer and turn on the resize handle as you would for embedded slicers.

Linking to the report

This is done in the same way as with embedded slicers. Workbook slicers appear in the slicer drop down, and you can also configure an output cell which can drive the report.

Compatibility

These slicers will publish to XLCubed Web Edition, but are not available in Excel 2003 or earlier.