Macro Pivot Table Not Working for Certain Computer

Hello,

We have a macro for use that involves creating pivot tables. The macro works just fine when I run it from my computer, but when a co-worker runs it exactly the same way (and I am there to make sure we are running it the same way), the macro errors out during the point where it starts to run pivot tables. Below is the code highlighted in yellow as the "error" on her end:

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Breakdown!R1C1:R1048576C4", Version:=6).CreatePivotTable TableDestination _
:="Breakdown!R8C6", TableName:="PivotTable15", DefaultVersion:=6

I cannot identify why this portion works for my computer, but not on hers (others also do not have the issue she is having).

Thank you in advance for your help!

The specified version 6 is used in your code, try delete some code ", Version:=6"

Hello,

I attempted to delete some of the code recommended above, and when I run the macro again, it errors out at that point. Is there maybe something I can put in place of the ", Version=6" insterad of deleting it?

Thank you!

Hello,

I don't want to change that number, because the number of values that could be submitted into the table, while maybe not a million) could reach upwards of a couple hundred thousand lines. I am thinking that the issue is the age of my colleague's computer, so I am hoping that there is something I can replace in the "version" section of the code to bypass an older version of Excel.

Thank you!