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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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	Enda80	Excel Worksheet Functions	1	May 3rd 08 02:35 PM
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	Enda80	Excel Discussion (Misc queries)	1	May 3rd 08 10:52 AM
Run-time error '1004': Unable to set the CategoryNames property of the Axis class	bodani	Excel Programming	0	June 30th 06 04:14 PM
Run-time error '1004': Unable to set the CategoryNames property of the Axis class	bodani	Excel Programming	0	June 30th 06 04:14 PM
Run time error 1004 - Unable to get add property of the buttons class	Mark[_37_]	Excel Programming	0	March 1st 04 09:48 AM

All times are GMT +1. The time now is 10:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us