Save Pivot Table Format in 2007

[Joyce]

In Excel 2003 you could save a Pivot table format and apply other worksheets
to it, can you do that in 2007? If so how?

 

[ShaneDevenshire]

Hi,


--
Thanks,
Shane Devenshire

1. What do you mean by saving a pivot table format? In Excel 2003 there is
no command called save pivot table format. You can use the built in
autoformats, but they are very limited and you don't have the ability to
customize them or save them.

2. In 2007 the pivot tables allow you to customize the pivot table styles,
and the styles are much more complex and attractive and flexible. And in
2007 you can save these which you could not do in 2003.

 

[Joyce]

Thanks for the info! You are correct. After I actually took the time to
play with it there is much more flexibility in 2007. :0)