View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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