Hi everybody,

I have this VBA program which creates a Pivot table and a number of fields.

When I use it under Excel 2007 with 78,000 rows, it couldn't create the
pivot table.
- When I reduce the table to 6000 rows, the program could complete.
- When I create the pivot table manually, it could follow through.

Is there a limit to the number of rows Excel 2007 could process?

Thanks

Ch

probably more to do with how much memory you're using, 32 bit Excel stuffs
pivot tables at about 1.8Gigs



"ch" wrote:

Hi everybody,

I have this VBA program which creates a Pivot table and a number of fields.

When I use it under Excel 2007 with 78,000 rows, it couldn't create the
pivot table.
- When I reduce the table to 6000 rows, the program could complete.
- When I create the pivot table manually, it could follow through.

Is there a limit to the number of rows Excel 2007 could process?

Thanks

Ch

Hi Patrick,

I have 2 Gbyte RAM.
Does the disk swap allow bigger chunks of data to be processed? My hard
disk is left with a few Gigs. Is that the cause?