Is there a limit for Pivot Tables under Excel 2007

  • Thread starter Thread starter ch
  • Start date Start date
C

ch

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
 
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?
 
Back
Top