automatically create tabs for every value in a pivot table

Hi,

I have made a pivot table with two columns, one with customer names and one with amounts of money to be invoiced. If i click on a cell containing an amount of money, excel automatically adds a tab for that customer containg all the data that could also be displayed in the pivot table. This is a very useful option, but it takes time to click on every single cell in the second column to create each tab for every customer. Is there a way to automatically do this?

Any input is much appreciated!

Hi

look for pivottable show report filter pages
In tab PivotTable Analyze go to Option (PivotTable), then select Report Filter Pages.

You need to have an item in the Filter area of the pivottable, otherwise it will be grey and can not be selected.

This will create one new sheet for each item of the filter,

Thank you for your reply. Unfortunately the option "report filter pages" is greyed out and can't be selected. Do you happen to know how to be able to use this option?

Originally Posted by hansolu

Hi
You need to have an item in the Filter area of the pivottable, otherwise it will be grey and can not be selected.

Thats what i was writing if you read my post. There is another setting in the options of Excel which could cause the greyed field. Dont know by heart what exactly, but easy to find if you search for it.