How to define a default Pivot Table style in 2007

[Mirlynn]

Two part question on styling pivot tables....

1. How do I set the default style for a pivot table?
I would like to be able to create a new pivot table and not have to apply my preferred design each and every time I create a new pivot.

2. How to define a default style for a worksheet that is generated/created when double clicking on a value in the pivot (aka drilling down)?
Right now, everytime I drill down into a pivot, the worksheet that opens up is in a default blue style. I would REALLY like to change that to match the design I have already applied in the pivot table itself. Is this possible to define?

Thanks in advance!!!

 

[Dryver14]

The best way to do this is to record a macro while you set up to the format you want