I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to
reset to sum instead of count.

It's extremely time consuming and very frustrating.

Any suggestions?

You cannot change the default settings. Check out the below link by Debra
Dalgleish for Add-In

Search for "Can I change the default summary function for data from COUNT to
SUM"

http://contextures.com/xlfaqPivot.html#DefaultSUM

If this post helps click Yes
---------------
Jacob Skaria


"mgville" wrote:

I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to
reset to sum instead of count.

It's extremely time consuming and very frustrating.

Any suggestions?

Thanks Jacob.

I did find something else for Excel 2007.

Create your pivot table, select the values you want, click on the tool bar
and select 'Add-Ins'. Select the option called 'PIVOT', select 'Data
Fields...', SUM All Data.

Misty







"Jacob Skaria" wrote:

You cannot change the default settings. Check out the below link by Debra
Dalgleish for Add-In

Search for "Can I change the default summary function for data from COUNT to
SUM"

http://contextures.com/xlfaqPivot.html#DefaultSUM

If this post helps click Yes
---------------
Jacob Skaria


"mgville" wrote:

I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to
reset to sum instead of count.

It's extremely time consuming and very frustrating.

Any suggestions?

Thanks for posting this..Im currently using Office 2003. Will definitely try
this in '07...

"mgville" wrote:

Thanks Jacob.

I did find something else for Excel 2007.

Create your pivot table, select the values you want, click on the tool bar
and select 'Add-Ins'. Select the option called 'PIVOT', select 'Data
Fields...', SUM All Data.

Misty







"Jacob Skaria" wrote:

You cannot change the default settings. Check out the below link by Debra
Dalgleish for Add-In

Search for "Can I change the default summary function for data from COUNT to
SUM"

http://contextures.com/xlfaqPivot.html#DefaultSUM

If this post helps click Yes
---------------
Jacob Skaria


"mgville" wrote:

I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to
reset to sum instead of count.

It's extremely time consuming and very frustrating.

Any suggestions?

Field Settings is possible in Office 2003 too. We can switch between many
options in Field Settings.

Jaleel

"Jacob Skaria" wrote:

Thanks for posting this..Im currently using Office 2003. Will definitely try
this in '07...

"mgville" wrote:

Thanks Jacob.

I did find something else for Excel 2007.

Create your pivot table, select the values you want, click on the tool bar
and select 'Add-Ins'. Select the option called 'PIVOT', select 'Data
Fields...', SUM All Data.

Misty







"Jacob Skaria" wrote:

You cannot change the default settings. Check out the below link by Debra
Dalgleish for Add-In

Search for "Can I change the default summary function for data from COUNT to
SUM"

http://contextures.com/xlfaqPivot.html#DefaultSUM

If this post helps click Yes
---------------
Jacob Skaria


"mgville" wrote:

I rarely use count in my pivot tables, is there a setting I can change in
excel so that when I select my values, which is usually 5 or more, I have to
reset to sum instead of count.

It's extremely time consuming and very frustrating.

Any suggestions?