Pivot tabels - auto foramtting when doubleclicking

H

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
 
D

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.
 
D

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)
 
D

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


Dave said:
It does look like it's list3 (but I don't like list3!). <vbg>
Click to expand...
 
D

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).

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

Sub FormatPivotDetail()
Selection.ShowDetail = True
Selection.AutoFormat _
Format:=xlRangeAutoFormatSimple
End Sub
Click to expand...
 
Top