Thread: I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default 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,
See your other post. Please do not multipost.

Regards,
Fred.

"Enda80" wrote in message
...
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 With QuoteReply With Quote