Pivot tabels - auto foramtting when doubleclicking

[H. Rye]

When I doubleclik in my pivot table, a new sheet is created, showing the
details behind the cell content in the pivot table.

When this new sheet is created, a kind of auto formatting is applied to the
new sheet. My question is: How can I control this formating? Where does
Excel get theese formats from? Some times I get quite weird results...

I´m using Excel 2000.

Hope anybody out there can help me.

Håvard

 

[Dave Peterson]

I don't think you can control them (or at least I can't!).

But maybe you can go back to the raw data worksheet and select your range and
use the Format|painter icon to use the same format again.

 

[Debra Dalgleish]

Or select one of the formats from Format>AutoFormat (when you extract
data from the pivot table, it seems to apply List3 format)

 

[Dave Peterson]

It does look like it's list3 (but I don't like list3!). <vbg>

 

[Debra Dalgleish]

Oh no! Too colourful for you? Maybe 'Simple' is more your style.

Sub FormatPivotDetail()
Selection.ShowDetail = True
Selection.AutoFormat _
Format:=xlRangeAutoFormatSimple
End Sub

It does look like it's list3 (but I don't like list3!). <vbg>

 

[Dave Peterson]

I it to use the same formatting as the original data--I want the same wraptext
options, colors, bolding, everything.

But that sounds pretty difficult. Maybe I shouldn't ask. (hehehe).

Oh no! Too colourful for you? Maybe 'Simple' is more your style.

Sub FormatPivotDetail()
Selection.ShowDetail = True
Selection.AutoFormat _
Format:=xlRangeAutoFormatSimple
End Sub