Pivot Table - Limitation in Total Records Fetched

[chouna]

I have a pivot that queries a Foxpro database of over 1M records. The query should return a record set of 410,000 items but it stops fetching data after 405,000 and pops up an error message that "Excel cannot cmplete this task with available resources. Choose less data or close other applications." I have 512MB RAM.

I tried running it on our server with over 2GB RAM and still get the same response. My question is, what is restricting Excel from fetching all the records? Does it have any limitation on total records or is it limited by resource?

 

[SkipVought]

Hi,

Excel can only display 65536 rows.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[chouna]

Hi Skip,

The pivot table I have normally returns only 1,100 rows. It should not go beyond 1,500. If the result would go beyond 65,000, Excel gives me an error after I transpose fields, not when I am opening or refreshing the pivot.

Thanks

 

[SkipVought]

Other than that, it's a matter of horsepower. Try making more virtual memory.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}