Resulting Report from Pivot Drill Down?

[dem1an]

Is there a way to control the way the new sheet looks when you double click a number in pivot to drill down to the data underneath? Is there a way to control the format of this output?

Also, is it possible hook some additional functionality to a double click? Say for instance, I wanted to hide columns A & B?

Just a couple of things I've been wondering about.

Thanks

dem

 

[iliace]

PivotTable data is stored in a so-called PivotCache, which does not contain format information. Therefore the drill down operation will not preserve formats.

For double-click functionality, you can write an event macro that intercepts normal double-click operation.