Hi,

I recorded a macro that includes creating a pivot table. It runs just fine on my Windows PC but does not run on Mac. It gives errors message "Run-time error '1004': Method 'CreatePivotTable' of object 'PivotCache' failed." I am going crazy trying to make it work for mac but its just not working. Here is the code for this that shows error in debug:

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"DynamicRange", Version:=xlPivotTableVersion14).CreatePivotTable _
TableDestination:="", TableName:="PivotTable12", _
DefaultVersion:=xlPivotTableVersion14

I would really really appreciate if anybody could help me with the mac version for this code.