pivot table, show detail for multiple cells

[jensand]

Is there a way to show the detail for multiple cells in one step? Preferably
with each being on a separate sheet.

Thanks!

 

[Ed Ferrero]

Hi jensand,

If you have a Page Field you can use the 'Show Pages' item in the Pivot
Table menu to create multiple sheets, each with a pivot table for each item
in the Page Field.

Go to http://www.edferrero.com/ExcelTutorials/tabid/54/Default.aspx for a
Pivot Table tutorial.

Ed Ferrero
www.edferrero.com