Save a custom pivot table style EXCEL
up vote
0
down vote
favorite
I went to the effort of creating a custom pivot table design, to match my companies work colours.
I'm looking for a way to save a custom table style (not Workbook) as a template, so it can be used in other workbooks.
I have done this with several charts, which can then be used again, so was hoping it is also possible with a Pivot Table .
I have found a work around for this, I can copy the original created template and paste it into a new workbook, the design is then available to use, but surely there must be a way of saving the actual design ?!
microsoft-excel pivot-table templates
add a comment |
up vote
0
down vote
favorite
I went to the effort of creating a custom pivot table design, to match my companies work colours.
I'm looking for a way to save a custom table style (not Workbook) as a template, so it can be used in other workbooks.
I have done this with several charts, which can then be used again, so was hoping it is also possible with a Pivot Table .
I have found a work around for this, I can copy the original created template and paste it into a new workbook, the design is then available to use, but surely there must be a way of saving the actual design ?!
microsoft-excel pivot-table templates
Pivot tables and charts can be saved as an Excel template file (.xlt). Then you open the template, enter new data, and save the resulting file as .xlsx. Is that what you're looking for?
– Bandersnatch
Nov 9 '17 at 17:55
You could also define the style in code. Then run your VBA macro to insert the table with your styling in to active sheet. Like this: thespreadsheetguru.com/blog/2014/9/27/…
– HackSlash
Jun 8 at 19:56
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I went to the effort of creating a custom pivot table design, to match my companies work colours.
I'm looking for a way to save a custom table style (not Workbook) as a template, so it can be used in other workbooks.
I have done this with several charts, which can then be used again, so was hoping it is also possible with a Pivot Table .
I have found a work around for this, I can copy the original created template and paste it into a new workbook, the design is then available to use, but surely there must be a way of saving the actual design ?!
microsoft-excel pivot-table templates
I went to the effort of creating a custom pivot table design, to match my companies work colours.
I'm looking for a way to save a custom table style (not Workbook) as a template, so it can be used in other workbooks.
I have done this with several charts, which can then be used again, so was hoping it is also possible with a Pivot Table .
I have found a work around for this, I can copy the original created template and paste it into a new workbook, the design is then available to use, but surely there must be a way of saving the actual design ?!
microsoft-excel pivot-table templates
microsoft-excel pivot-table templates
edited Nov 15 at 9:58
asked Nov 9 '17 at 10:06
PeterH
3,09832245
3,09832245
Pivot tables and charts can be saved as an Excel template file (.xlt). Then you open the template, enter new data, and save the resulting file as .xlsx. Is that what you're looking for?
– Bandersnatch
Nov 9 '17 at 17:55
You could also define the style in code. Then run your VBA macro to insert the table with your styling in to active sheet. Like this: thespreadsheetguru.com/blog/2014/9/27/…
– HackSlash
Jun 8 at 19:56
add a comment |
Pivot tables and charts can be saved as an Excel template file (.xlt). Then you open the template, enter new data, and save the resulting file as .xlsx. Is that what you're looking for?
– Bandersnatch
Nov 9 '17 at 17:55
You could also define the style in code. Then run your VBA macro to insert the table with your styling in to active sheet. Like this: thespreadsheetguru.com/blog/2014/9/27/…
– HackSlash
Jun 8 at 19:56
Pivot tables and charts can be saved as an Excel template file (.xlt). Then you open the template, enter new data, and save the resulting file as .xlsx. Is that what you're looking for?
– Bandersnatch
Nov 9 '17 at 17:55
Pivot tables and charts can be saved as an Excel template file (.xlt). Then you open the template, enter new data, and save the resulting file as .xlsx. Is that what you're looking for?
– Bandersnatch
Nov 9 '17 at 17:55
You could also define the style in code. Then run your VBA macro to insert the table with your styling in to active sheet. Like this: thespreadsheetguru.com/blog/2014/9/27/…
– HackSlash
Jun 8 at 19:56
You could also define the style in code. Then run your VBA macro to insert the table with your styling in to active sheet. Like this: thespreadsheetguru.com/blog/2014/9/27/…
– HackSlash
Jun 8 at 19:56
add a comment |
2 Answers
2
active
oldest
votes
up vote
2
down vote
There is, but it ain't pretty:
- Copy a Table/PivotTable that uses the new Table Style into a new
blank workbook. - Setting that Table/PivotTable Style as the Default Style
- Delete that Table/PivotTable
- Save the workbook as an Excel Template in the Startup folder, so
that Excel will use this workbook – and your beautifew new Custom
Table/PivotTable Style – as a template whenever you create a new
document.
Read more at my blogpost at http://dailydoseofexcel.com/archives/2015/02/27/custom-table-styles/
add a comment |
up vote
0
down vote
Excel provides no way of transferring custom pivot table styles,
so transferring a custom style to new documents is difficult if it is
not already included in the template as described in the
answer by @jeffreyweir.
If you wish to transfer a custom style without using a document template,
this is done as follows.
Excel version from before 2016
- In any workbook containing the custom style, select any cell in the
pivot table that has that custom style applied. - On the Ribbon's Options tab, in the Actions group, click Select, and then click Entire PivotTable
- On the Ribbon's Home tab, click Copy.
- Switch to the new workbook.
- Select a blank worksheet, or insert a new blank worksheet.
- Select cell A1 on the blank worksheet.
- On the Ribbon's Home tab, click Paste.
- Delete the sheet that contains the pasted copy of the pivot table.
Your custom PivotTable style now appears in the PivotTable Styles gallery,
in the new workbook.
Excel version 2016
Unfortunately, in Excel 2016 the above method does not work and the custom
pivot table style is not copied. The following method works in
Excel 2016 and also in Excel 2013.
- Open the old workbook with the pivot table that has the custom style applied.
- Open the new workbook where you want to add that custom style
- Position the workbooks, so you can see the sheet tabs in both files
- Press Ctrl and drag a copy of the pivot table sheet from the old workbook into the new workbook.
- The custom style is now copied into the new workbook, and you can delete the sheet that you copied from the old workbook.
For more detailed information and screenshots see the article
Excel Pivot Table Format - Copy Custom Style to Different File.
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
There is, but it ain't pretty:
- Copy a Table/PivotTable that uses the new Table Style into a new
blank workbook. - Setting that Table/PivotTable Style as the Default Style
- Delete that Table/PivotTable
- Save the workbook as an Excel Template in the Startup folder, so
that Excel will use this workbook – and your beautifew new Custom
Table/PivotTable Style – as a template whenever you create a new
document.
Read more at my blogpost at http://dailydoseofexcel.com/archives/2015/02/27/custom-table-styles/
add a comment |
up vote
2
down vote
There is, but it ain't pretty:
- Copy a Table/PivotTable that uses the new Table Style into a new
blank workbook. - Setting that Table/PivotTable Style as the Default Style
- Delete that Table/PivotTable
- Save the workbook as an Excel Template in the Startup folder, so
that Excel will use this workbook – and your beautifew new Custom
Table/PivotTable Style – as a template whenever you create a new
document.
Read more at my blogpost at http://dailydoseofexcel.com/archives/2015/02/27/custom-table-styles/
add a comment |
up vote
2
down vote
up vote
2
down vote
There is, but it ain't pretty:
- Copy a Table/PivotTable that uses the new Table Style into a new
blank workbook. - Setting that Table/PivotTable Style as the Default Style
- Delete that Table/PivotTable
- Save the workbook as an Excel Template in the Startup folder, so
that Excel will use this workbook – and your beautifew new Custom
Table/PivotTable Style – as a template whenever you create a new
document.
Read more at my blogpost at http://dailydoseofexcel.com/archives/2015/02/27/custom-table-styles/
There is, but it ain't pretty:
- Copy a Table/PivotTable that uses the new Table Style into a new
blank workbook. - Setting that Table/PivotTable Style as the Default Style
- Delete that Table/PivotTable
- Save the workbook as an Excel Template in the Startup folder, so
that Excel will use this workbook – and your beautifew new Custom
Table/PivotTable Style – as a template whenever you create a new
document.
Read more at my blogpost at http://dailydoseofexcel.com/archives/2015/02/27/custom-table-styles/
edited 2 days ago
PeterH
3,09832245
3,09832245
answered Nov 9 '17 at 18:01
jeffreyweir
39617
39617
add a comment |
add a comment |
up vote
0
down vote
Excel provides no way of transferring custom pivot table styles,
so transferring a custom style to new documents is difficult if it is
not already included in the template as described in the
answer by @jeffreyweir.
If you wish to transfer a custom style without using a document template,
this is done as follows.
Excel version from before 2016
- In any workbook containing the custom style, select any cell in the
pivot table that has that custom style applied. - On the Ribbon's Options tab, in the Actions group, click Select, and then click Entire PivotTable
- On the Ribbon's Home tab, click Copy.
- Switch to the new workbook.
- Select a blank worksheet, or insert a new blank worksheet.
- Select cell A1 on the blank worksheet.
- On the Ribbon's Home tab, click Paste.
- Delete the sheet that contains the pasted copy of the pivot table.
Your custom PivotTable style now appears in the PivotTable Styles gallery,
in the new workbook.
Excel version 2016
Unfortunately, in Excel 2016 the above method does not work and the custom
pivot table style is not copied. The following method works in
Excel 2016 and also in Excel 2013.
- Open the old workbook with the pivot table that has the custom style applied.
- Open the new workbook where you want to add that custom style
- Position the workbooks, so you can see the sheet tabs in both files
- Press Ctrl and drag a copy of the pivot table sheet from the old workbook into the new workbook.
- The custom style is now copied into the new workbook, and you can delete the sheet that you copied from the old workbook.
For more detailed information and screenshots see the article
Excel Pivot Table Format - Copy Custom Style to Different File.
add a comment |
up vote
0
down vote
Excel provides no way of transferring custom pivot table styles,
so transferring a custom style to new documents is difficult if it is
not already included in the template as described in the
answer by @jeffreyweir.
If you wish to transfer a custom style without using a document template,
this is done as follows.
Excel version from before 2016
- In any workbook containing the custom style, select any cell in the
pivot table that has that custom style applied. - On the Ribbon's Options tab, in the Actions group, click Select, and then click Entire PivotTable
- On the Ribbon's Home tab, click Copy.
- Switch to the new workbook.
- Select a blank worksheet, or insert a new blank worksheet.
- Select cell A1 on the blank worksheet.
- On the Ribbon's Home tab, click Paste.
- Delete the sheet that contains the pasted copy of the pivot table.
Your custom PivotTable style now appears in the PivotTable Styles gallery,
in the new workbook.
Excel version 2016
Unfortunately, in Excel 2016 the above method does not work and the custom
pivot table style is not copied. The following method works in
Excel 2016 and also in Excel 2013.
- Open the old workbook with the pivot table that has the custom style applied.
- Open the new workbook where you want to add that custom style
- Position the workbooks, so you can see the sheet tabs in both files
- Press Ctrl and drag a copy of the pivot table sheet from the old workbook into the new workbook.
- The custom style is now copied into the new workbook, and you can delete the sheet that you copied from the old workbook.
For more detailed information and screenshots see the article
Excel Pivot Table Format - Copy Custom Style to Different File.
add a comment |
up vote
0
down vote
up vote
0
down vote
Excel provides no way of transferring custom pivot table styles,
so transferring a custom style to new documents is difficult if it is
not already included in the template as described in the
answer by @jeffreyweir.
If you wish to transfer a custom style without using a document template,
this is done as follows.
Excel version from before 2016
- In any workbook containing the custom style, select any cell in the
pivot table that has that custom style applied. - On the Ribbon's Options tab, in the Actions group, click Select, and then click Entire PivotTable
- On the Ribbon's Home tab, click Copy.
- Switch to the new workbook.
- Select a blank worksheet, or insert a new blank worksheet.
- Select cell A1 on the blank worksheet.
- On the Ribbon's Home tab, click Paste.
- Delete the sheet that contains the pasted copy of the pivot table.
Your custom PivotTable style now appears in the PivotTable Styles gallery,
in the new workbook.
Excel version 2016
Unfortunately, in Excel 2016 the above method does not work and the custom
pivot table style is not copied. The following method works in
Excel 2016 and also in Excel 2013.
- Open the old workbook with the pivot table that has the custom style applied.
- Open the new workbook where you want to add that custom style
- Position the workbooks, so you can see the sheet tabs in both files
- Press Ctrl and drag a copy of the pivot table sheet from the old workbook into the new workbook.
- The custom style is now copied into the new workbook, and you can delete the sheet that you copied from the old workbook.
For more detailed information and screenshots see the article
Excel Pivot Table Format - Copy Custom Style to Different File.
Excel provides no way of transferring custom pivot table styles,
so transferring a custom style to new documents is difficult if it is
not already included in the template as described in the
answer by @jeffreyweir.
If you wish to transfer a custom style without using a document template,
this is done as follows.
Excel version from before 2016
- In any workbook containing the custom style, select any cell in the
pivot table that has that custom style applied. - On the Ribbon's Options tab, in the Actions group, click Select, and then click Entire PivotTable
- On the Ribbon's Home tab, click Copy.
- Switch to the new workbook.
- Select a blank worksheet, or insert a new blank worksheet.
- Select cell A1 on the blank worksheet.
- On the Ribbon's Home tab, click Paste.
- Delete the sheet that contains the pasted copy of the pivot table.
Your custom PivotTable style now appears in the PivotTable Styles gallery,
in the new workbook.
Excel version 2016
Unfortunately, in Excel 2016 the above method does not work and the custom
pivot table style is not copied. The following method works in
Excel 2016 and also in Excel 2013.
- Open the old workbook with the pivot table that has the custom style applied.
- Open the new workbook where you want to add that custom style
- Position the workbooks, so you can see the sheet tabs in both files
- Press Ctrl and drag a copy of the pivot table sheet from the old workbook into the new workbook.
- The custom style is now copied into the new workbook, and you can delete the sheet that you copied from the old workbook.
For more detailed information and screenshots see the article
Excel Pivot Table Format - Copy Custom Style to Different File.
edited Jul 24 at 11:06
answered Jun 6 at 20:15
harrymc
247k10256542
247k10256542
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1266871%2fsave-a-custom-pivot-table-style-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Pivot tables and charts can be saved as an Excel template file (.xlt). Then you open the template, enter new data, and save the resulting file as .xlsx. Is that what you're looking for?
– Bandersnatch
Nov 9 '17 at 17:55
You could also define the style in code. Then run your VBA macro to insert the table with your styling in to active sheet. Like this: thespreadsheetguru.com/blog/2014/9/27/…
– HackSlash
Jun 8 at 19:56