Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when runing macro to create pivot table
Hi,
I created a macro (recorded macro)to make a pivot Table. The generated code is the following: (...) Columns("A:H").Select ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ "relat!C1:C8").CreatePivotTable TableDestination:="", TableName:= _ "TD Vendas" ActiveSheet.Name = "TPVsIva" ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1) ActiveSheet.Cells(3, 1).Select ActiveSheet.PivotTables("TD Vendas").SmallGrid = False ActiveSheet.PivotTables("TD Vendas").AddFields RowFields:=Array( _ "Estrutura", "Dados"), PageFields:="Loja" (...) When I run the macro appears an error in the last line, where I'm adding fields. The error is : "Run Time Error '1004'" with the message "It was not possible to execute the Addfields method of the PivotTables collection" Can you help me? Thanks Bruno .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | Excel Worksheet Functions | |||
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 | Excel Discussion (Misc queries) | |||
Record Macro to Create Pivot Table | Excel Discussion (Misc queries) | |||
Can I run a macro to create a pivot table? | Excel Discussion (Misc queries) | |||
Macro to create pivot table/ chart | Excel Programming |