Pivot Table Field Settings
 

I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields.

Can I change the default sub-total field setting to "None", instead of
"Automatic"?

It's kind of a pain to constantly change the field setting everytime I move
data around.

I don't know of a way to change the default setting for subtotals. After
you've created the pivot table, you could use a macro to turn them off.
There's code to do that in my pivot table add-in, that you can download
he

http://www.contextures.com/xlPivotAddIn.html


Pivot Novice wrote:
I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields.

Can I change the default sub-total field setting to "None", instead of
"Automatic"?

It's kind of a pain to constantly change the field setting everytime I move
data around.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

That's AWESOME!
Thanks a lot.

"Debra Dalgleish" wrote:

I don't know of a way to change the default setting for subtotals. After
you've created the pivot table, you could use a macro to turn them off.
There's code to do that in my pivot table add-in, that you can download
he

http://www.contextures.com/xlPivotAddIn.html


Pivot Novice wrote:
I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields.

Can I change the default sub-total field setting to "None", instead of
"Automatic"?

It's kind of a pain to constantly change the field setting everytime I move
data around.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome! I hope it helps.

Pivot Novice wrote:
That's AWESOME!
Thanks a lot.

"Debra Dalgleish" wrote:


I don't know of a way to change the default setting for subtotals. After
you've created the pivot table, you could use a macro to turn them off.
There's code to do that in my pivot table add-in, that you can download
he

http://www.contextures.com/xlPivotAddIn.html


Pivot Novice wrote:

I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields.

Can I change the default sub-total field setting to "None", instead of
"Automatic"?

It's kind of a pain to constantly change the field setting everytime I move
data around.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Wow, that's great! Thanks for your hard work and sharing it with us!!!!!

"Debra Dalgleish" wrote:

I don't know of a way to change the default setting for subtotals. After
you've created the pivot table, you could use a macro to turn them off.
There's code to do that in my pivot table add-in, that you can download
he

http://www.contextures.com/xlPivotAddIn.html


Pivot Novice wrote:
I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields.

Can I change the default sub-total field setting to "None", instead of
"Automatic"?

It's kind of a pain to constantly change the field setting everytime I move
data around.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome!

Ngan wrote:
Wow, that's great! Thanks for your hard work and sharing it with us!!!!!

"Debra Dalgleish" wrote:


I don't know of a way to change the default setting for subtotals. After
you've created the pivot table, you could use a macro to turn them off.
There's code to do that in my pivot table add-in, that you can download
he

http://www.contextures.com/xlPivotAddIn.html


Pivot Novice wrote:

I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields.

Can I change the default sub-total field setting to "None", instead of
"Automatic"?

It's kind of a pain to constantly change the field setting everytime I move
data around.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html