G Guest May 1, 2007 #1 Is there a way to show the detail for multiple cells in one step? Preferably with each being on a separate sheet. Thanks!
Is there a way to show the detail for multiple cells in one step? Preferably with each being on a separate sheet. Thanks!
E Ed Ferrero May 1, 2007 #2 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
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
