+ Reply to Thread
Results 1 to 30 of 30

Pivot Table Field Settings

  1. #1
    Pivot Novice
    Guest

    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.


  2. #2
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    here:

    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


  3. #3
    Pivot Novice
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  4. #4
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  5. #5
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  6. #6
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  7. #7
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  8. #8
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  9. #9
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  10. #10
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  11. #11
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  12. #12
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  13. #13
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  14. #14
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  15. #15
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  16. #16
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  17. #17
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  18. #18
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  19. #19
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  20. #20
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  21. #21
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  22. #22
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  23. #23
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  24. #24
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  25. #25
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  26. #26
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  27. #27
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  28. #28
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


  29. #29
    Ngan
    Guest

    Re: Pivot Table Field Settings

    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
    > here:
    >
    > 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
    >
    >


  30. #30
    Debra Dalgleish
    Guest

    Re: Pivot Table Field Settings

    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
    >>here:
    >>
    >> 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1