PivotTable error

[Niranjanrajrishi]

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=Pivotrange, Version:=xlPivotTableVersion15).CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion15

Hi,

Need help with the attached code. The code to generate Pivot works in some systems and does not work is some systems. So any idea what could be the error?

 

[GraH - Guido]

With system do you mean versions of Excel?
Have a read on https://docs.microsoft.com/en-us/do....excel.xlpivottableversionlist?view=excel-pia

 

[Niranjanrajrishi]

Thank you....it was the version error and resolved when we upgraded to 2016.