Hi,

What exactly are you trying to do? If you want Excel to provide you with a
copy of the data that products the number you are clicking on, then forget a
macro, just double click the number. If you double-click a subtotal or grand
total you get all the records that contribute to that number.

If this is not what you want, we really need a lot more details. With this
feature on you won't be able to select an format within the pivot table and
you will be launching the macro everytime you click in the data field.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pgarcia" wrote:

Hello all,
When you click on the data the piovt provides, it brings up a new spread
sheet with the data. How can I have a macro run on the new sheet?

thanks