Range limit as data source on Pivot table through VBA

[jak82]

Hi,

I have noticed when I use the range as a data source it seems to stop working after so many row.

On looking online it seems that the best way is to put it as a string.

I am setting the string as

PRange = Source & "!A1:B" & LastRow

Which Generates "Database Data!A1:B70000"

I am then setting the cache using

Set PCache = ActiveWorkbook.PivotCaches.Create _
(SourceType:=xlDatabase, SourceData:=PRange). _

and then



But for some reason it does not create the pivot table.

CreatePivotTable(TableDestination:=PSheet.Cells(2, 2), _
TableName:="SalesPivotTable")

But for some reason it does not create the pivot table?

Any ideas

Thanks

 

[jak82]

It seems to be the number of rows limit through VBA....
If I have

"Database Test!R1C1:R7000") it works

"Database Test!R1C1:R83708") doesnt.