Double clicking on a pivot table

[Jennifer]

Here it goes,
Can you double click on a pivot table and instead of it pulling out the
informatoin and putting it on a whole new worksheet have the data go to a
specific worksheet say between a1:d1 or a dynamic range?

 

[Dave Peterson]

I don't think you can change this behavior.

Here it goes,
Can you double click on a pivot table and instead of it pulling out the
informatoin and putting it on a whole new worksheet have the data go to a
specific worksheet say between a1:d1 or a dynamic range?

 

[DomThePom]

One way of doing this is as follows:

The deault behaviour response to a double-click on a pivot item is to creae
a new worksheet that lists the detai behind the item clicked.

If you want to change this default behaiour then enter code into the
newSheet event of the wokbook object. For exaple you could cop the date to
some otyher location and tehn delete the additional sheet that was created
whne you double-clicked on the pivot

 

[Jennifer]

Interesting! Thanks i'll try.