Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I set Excel 2007 pivot table default to not save source dat | Excel Discussion (Misc queries) | |||
*.csv format change if .xlt save as .csv in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot table cells number format changes w/out user inpu | Excel Discussion (Misc queries) | |||
Conditional format a pivot table in 2007 | Excel Discussion (Misc queries) |