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.