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