Save Pivot Table Format in 2007

  • Thread starter Thread starter Joyce
  • Start date Start date
J

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?
 
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I save Pivot Table Data 4
excel 2007 pivot table: how to paste special formats? 1
Excel 2007 pivot table source table 1
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Pivot Table Formats 2
2007 to 2003 Formating issues 1
Single Filter to change all Pivot Tables in a Workbook 8
Pivot Table date format 1

Back
Top