I want to create a custom pivot table format, with custom colors etc... How do I do this?
S Scott Good Sep 5, 2003 #1 I want to create a custom pivot table format, with custom colors etc... How do I do this?
D Debra Dalgleish Sep 5, 2003 #2 You can't add to the list of AutoFormats for a PivotTable, but you could record a macro as you apply formatting, then run that macro to apply formatting to your PivotTables.
You can't add to the list of AutoFormats for a PivotTable, but you could record a macro as you apply formatting, then run that macro to apply formatting to your PivotTables.
