If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Save Pivot Table Format in 2007
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? |
#2
|
|||
|
|||
Save Pivot Table Format in 2007
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" wrote: 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? |
#3
|
|||
|
|||
Save Pivot Table Format in 2007
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) "ShaneDevenshire" wrote: 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" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|