Run-timer error '5" invalid procedure call or argument

[preciousakky]

Hi,

I recorded a macro to create a pivot table. so okay everything okay but when I run the macro to check if it goes smoothly it appears like this. Run-timer error '5" invalid procedure call or argument

Run-timer error '5" invalid procedure call or argument

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"dunidata!R1C1:R60000C9", Version:=xlPivotTableVersion14).CreatePivotTable _
TableDestination:="Pivot!R1C1", TableName:="PivotTable", DefaultVersion _
:=xlPivotTableVersion14

can someone help me please.

sometimes if I change on the version to 12 and error also will also as runtime error 1004 I cannot figure out where is the mistake.

thanks in advance.
preciousakky