Pivot Table question

[reemoe]

I was told that Pivot Tables have the ability to 'explode' the data and create worksheet tabs automatically. Is this true? How is it done?

Thanks in advance!
Ryan

 

[Oaktree]

Try double clicking on the bottom right cell in your pivot table (the value associated with grand total).

In fact, try double clicking on just about any area in a pivot table to make it "explode"