Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
turn off auto subtotal
is there a way to turn off the auto-subtotal when using pivot table fields? I
turned of the grand totals, but I still end up having to double click on the column name and choosing none from the subtotals for every column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
turn off auto subtotal
There's no way to turn the feature off. You can use programming to turn
off all the subtotals, as in the sample code he http://www.contextures.com/xlPivot03.html#Subtotals jenn wrote: is there a way to turn off the auto-subtotal when using pivot table fields? I turned of the grand totals, but I still end up having to double click on the column name and choosing none from the subtotals for every column. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
turn off auto fill options box Excel 2003 | Excel Discussion (Misc queries) | |||
Auto Filter + subtotal | Excel Discussion (Misc queries) | |||
How do I turn off auto correct? | Excel Discussion (Misc queries) | |||
Auto Filter + subtotal | Excel Worksheet Functions | |||
How can I turn auto correct on or off for one column only? | Excel Worksheet Functions |