Custom Pivot Table Styles Saved as Default at Application Level

Hamburgler

Board Regular
Joined
May 16, 2009
Messages
148
When creating a custom Excel PivotTable Style there is an option to "Set as default PivotTable quick style for this document". If it is not set as default then it is still saved within the workbook and available through the "PivotTable Styles" Ribbon Control in the context "Design" ribbon tab.

But custom styles only seem to be saved within a workbook. Is it possible to make them available at the application level (i.e. always available)?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
No, I don't think there is any way to save the pivot table styles at the application level so they can be used by any workbooks.

The Contextures site suggests a workaround.
http://www.contextures.com/excel-pivot-table-format.html#file

One further step might be to save your favorite customs style(s) in a template file, then use a macro to Open the template file and do the copy-paste-delete steps in the suggested workaround.
 
Upvote 0

Forum statistics

Threads
1,216,031
Messages
6,128,422
Members
449,450
Latest member
gunars

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top