drill down worksheet placement (pivot tables)
 

For pivot tables: When I select a cell and double click on that cell a new
sheet is created showing all the detail for that pivot table.

However the sheet is placed befor the pivot table. Is there a way to edit
this so that when I drill down, the new sheet is placed after the pivot table
instead of before?

Hope someone can help, this will add significant value to my distribution
process.

Thanks,

Joseph

drill down worksheet placement (pivot tables)
 

To the best of my knowledge there is no way to specify before or after on
either Drill Down or Show Pages...
--
HTH...

Jim Thomlinson


"jbJB" wrote:

For pivot tables: When I select a cell and double click on that cell a new
sheet is created showing all the detail for that pivot table.

However the sheet is placed befor the pivot table. Is there a way to edit
this so that when I drill down, the new sheet is placed after the pivot table
instead of before?

Hope someone can help, this will add significant value to my distribution
process.

Thanks,

Joseph