Hi all,

Background:
Using excel 2007.
Data file has ~ 85,000 rows of data.
Data file has ~ 20 columns of data.

I am getting a type mismatch error when i try to create the pivot table using the following vba code:
Set cacheofPt = wb_pivot.PivotCaches.Create(xlDatabase, data_range)
i thought this was strange to get a failure here because i had used this code before in other files.

The file size was rather large and was taking awhile to finish so i decided to reduce the input file size just so i could troubleshoot file quicker.

Turns out..............i dont get the error when i reduce the number of rows from ~85,000 to 53000. Kept number of cols the same....

So the code shown above works but not when the number of rows is ~ 85,000...........

Any one have an idea whats going on?