Is there a limit for Pivot Tables under Excel 2007
 

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

Is there a limit for Pivot Tables under Excel 2007
 

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

Is there a limit for Pivot Tables under Excel 2007
 

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?