Is there a limit for Pivot Tables under Excel 2007

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
 
P

Patrick Molloy

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DYNAMIC RANGE FOR PIVOT TABLE 1
Excel 2007 pivot tables - calculated fields and SSAS cube 3
Using VBA on Excel Pivot Tables 3
Pivot Table with Percentages 4
Excel 2007 Pivot Tables - Updated Data Source 1
Excel 2007: "Reference is not valid" when refreshing pivot table 2
Excel VBA For excel 0
Question on pivot tables 1

Top