I tried to get around the problem of the pivot table field setting defaulting to Count instead of Sum by running a macro of change the setting from Count to Sum. However, when I tried to run the Macro, I got error message of run time error 1004, unable to get the pivot fields property of the pivot field class.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Enda80 - 03 May 2008 01:04 GMT

I tried to get around the problem of the pivot table field setting
defaulting to Count instead of Sum by running a macro of change the
setting from Count to Sum. However, when I tried to run the Macro, I
got error message of run time error 1004, unable to get the pivot
fields property of the pivot field class.

Well, is there any way around this?

Reply to this Message

Fred Smith - 03 May 2008 14:35 GMT

See your other post. Please do not multipost.

Regards,
Fred.

>I tried to get around the problem of the pivot table field setting
> defaulting to Count instead of Sum by running a macro of change the
[quoted text clipped - 3 lines]
>
> Well, is there any way around this?

Reply to this Message