Copy PivotTable Style

Yesterday, i created a custom PivotTable Style for a customer, to make it easy to format multiple pivot tables, using their corporate colour scheme.

PivotTable Styles are available in Excel 2010 and Excel 2007, and if you don’t like the existing styles, you can create your own custom styles, and apply those to any pivot table.

Copy Custom PivotTable Styles

Unfortunately, there’s no built in way to copy a custom PivotTable style from one workbook to another. A while ago, I made this video, to show you a workaround for copying your favourite styles to a different workbook.

Remove Existing Formatting

If you’re applying a built-in or a custom style to a pivot table, you might need to remove any manually applied formatting first.

  • Instead of clicking on the PivotTable Style icon, right-click on it.
  • Then, click Apply and Clear Formatting

pivottablestyle01

You might need to tidy up the pivot table after you apply the new style, but with Custom Styles you can quickly format your pivot tables, so they have a consistent appearance.

______________________

You may also like...

7 Responses

  1. Fakhar Hussain says:

    Dear Debra,

    Very useful like always, please add a video on “create a custom pivot table style” as well.

    May God bless you. You are doing a great service by spreading knowledge to all

    Thanks and regards
    Fakhar

  2. Vivek Singh says:

    Hi,

    Thank you for your tutorial. I am trying to create a custom style with alternating color for each column. Somehow I am not able to do it. U have tried the Banded Row option but it does not reflect the alternating colors in the first column.

    Can you provide some information on the same?
    Thank you and regards,
    Vivek

  3. Caula says:

    Hi Debra,
    I have followed your instructions for copying a custom pivot table style but for some reason the style arrives at the destination workbook modified, i.e., different colours from the copied original. Puzzling…

    The other thing is that the style is a dark p-table with light coloured fonts on a worksheet with the same dark fill. When the p-table changes size and takes a smaller area area, the worksheet loses the dark fill in the area previously occupied by the p-table and white patches appear. Dos that make sense? Do you think you can reproduce this on your side? Any ideas as to why this happens?

    Thanks,

    Caula

  4. Rutika says:

    Hello,
    I have already saved my custome style template for tables in excel, for getting the same custom style in pivots do we have to save it all over again? Or is there any way to copy paste the custom table format to custom pivot format?

    Thanks,
    Rutika.

  1. January 13, 2013

    […] I found Debra Dalgleish’s post regarding copying custom PivotTable styles to a new workbook (http://blog.contextures.com/archives/2012/04/05/copy-pivottable-style/). The code below was developed after 1) not finding it on a web search, and 2) using Debra’s […]

  2. November 8, 2013

    […] I mean, you can with charts. It’s pretty insane. But there is a hack to get around this that I learned from the Contextures blog. And I mean […]

  3. November 8, 2013

    […] I mean, you can with charts. It’s pretty insane. But there is a hack to get around this that I learned from the Contextures blog. And I mean […]

Leave a Reply

Your email address will not be published. Required fields are marked *