Microsoft Excel Slicers

Hi Kome

The good thing about Slicers is you can filter by fields that have note been added to the . This can cause a problem if you double click to see the detail. Only the fields added to the pivot table with control the items in the detail sheet. Fields in Slicers that are being use exclusively as Slicers won't apply to the detailed data sheets - so you will probably end up with more data than you wanted when you double click.

As far as I am aware in Excel 2010 the only answer is to add the field both to the pivot table and the slicers at the same time.

Let me know if you have any further questions.

Kind regards,
Andrew

Hi Kome,

When you double click on a cell within a Pivot it gives you a copy of the source data.

There isn't a way to click on a slicer button and have it generate a sheet of data.

When you create a Pivot Table if you drop the Category you would like, into the Filer box, rather than making it a slicer.

Then in the Pivot Table Tabs along the top (for 2010 users) click on Options tab.

Far left is another smaller box called Options (just below the Pivot Table Name), click the drop down arrow on the Options Button.

In that list is the Show report filter Pages

This will generate individual Pivot Tables for every Button that would have been in your Slicer.

Hopefully that helps you to generate lots of individual sheets.

Kind regards

Richard Bailey
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector