Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
There were a few things I was hoping MS would change for this new version of
Excel, and one of them was being able to set your own DEFAULTS for Pivot Tables. I haven't found any way to do this yet... in fact, it looks like it's more work for me to get the table the way I want it to be. Can anyone tell me whether its possible to change some of the basic defaults for Pivot Tables? The things Im interested in a - having the subtotals defaulted to 'none' - having the pivot table borders defaulted to how they used to be (they offer dozens of new styles, yet none are how the standard border default used to be) - having numbers in my Values column defaulted to currency, no decimal places - when I create a new Pivot table, the new default is an Outline style, whereas I need the old tabular €“ I can change this but it means I have to go into the field options *for every single field* and change it tabular. This was one of the huge time-wasters previously... and now it looks like we have to waste even more time. :( Any help on this appreciated! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
As far as I know, you can't change the defaults, but after you create a
pivot table you can do the following: On the Ribbon, under the PivotTable Tools tab, click Design In the Layout group, click Subtotals, and click Do Not Show Subtotals In the PivotTable Styles group, click the More button at the far right At the bottom of the PivotTable Styles gallery, click on Clear In the Layout group, click Report Layout, and click Tabular HmE wrote: There were a few things I was hoping MS would change for this new version of Excel, and one of them was being able to set your own DEFAULTS for Pivot Tables. I haven't found any way to do this yet... in fact, it looks like it's more work for me to get the table the way I want it to be. Can anyone tell me whether its possible to change some of the basic defaults for Pivot Tables? The things Im interested in a - having the subtotals defaulted to 'none' - having the pivot table borders defaulted to how they used to be (they offer dozens of new styles, yet none are how the standard border default used to be) - having numbers in my Values column defaulted to currency, no decimal places - when I create a new Pivot table, the new default is an Outline style, whereas I need the old tabular €“ I can change this but it means I have to go into the field options *for every single field* and change it tabular. This was one of the huge time-wasters previously... and now it looks like we have to waste even more time. :( Any help on this appreciated! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yeah, it's really the defaults I'm interested in, so that I don't have to do
this for every single table. Does anyone know if there are any add-ins available (or in the works) to allow us to set our own defaults? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table issue in Excel 2007 | Excel Discussion (Misc queries) | |||
function defaults change in Pivot Table..why? | Excel Discussion (Misc queries) | |||
Pivot table, summary function defaults | Excel Discussion (Misc queries) |