Pivot Table Style design

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
I want to create my own pivot table style but I have difficulty to refer to the right pivot table element during design.
Just wonder there is no preview from my pivot table.
Did you face the same problem?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
There is in 2013.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
I get previews in 2010...

Live preview of existing styles before I select them definitely work.

When I'm creating a custom PivotTable style, the "Preview" image in the Create (modify) PivotTable Quick style works.

What is won't do is show in the real PivotTable as you're building it. The new style actually isn't even applied to your table until you select it (after exiting the creation wizard), and any modification won't apply until you exit the modification dialog.
 
Top