Pivot Table Style/Formatting

lax4673

New Member
Joined
Jun 27, 2011
Messages
14
I really like a pivot table style that I've used in Excel 2007 for years. We are now switching over to 2010 and the same style isn't an option. I have tried to customize my own style to match 2007's version, but I can't seem to get it exactly right. Is there anyway that I would able to easily copy the style into 2010? I have tried copy and pasting an old table, but it doesn't recognize the style.

Any help would be greatly appreciated. Thanks!
 
Thank you!

That would explain it. :)
I think you may be one of the very few who actually prefers the 2003 formatting to the newer versions. There is no easy way to copy that over, you would have to try and create as close a version as you can in 2010.
 
Upvote 0

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,224,603
Messages
6,179,849
Members
452,948
Latest member
UsmanAli786

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