| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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,
Hi
Post the code you are using, and maybe someone can help. In future, please avoid typing the whole of your question in the subject line. -- Regards Roger Govier "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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unable to protect cells in macro sheet b/c runtime error 1004 | Excel Worksheet Functions | |||
| Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
| change 'count of' to 'sum of' in pivot table field | Excel Discussion (Misc queries) | |||
| MACRO Run Time Error 1004 | Excel Discussion (Misc queries) | |||
| VBA error: Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
Linear Mode
