You can use the existing formats (FormatAutoFormat), but you can't
create your own formats and add them to that list.


pivot table design templates wrote:
Is there anyway to set up a standard design format for pivot tables (ie.
patterns, alignment, column/row height/width etc) ?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html