MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Table Limits

Posted by Martin on June 16, 2001 2:31 AM

Is there anyway in which pivot table data can go over more than one sheet (i.e. 65,000 lines)
I have tried using the multiple consolidation ranges, but without much success.

Posted by Mark W. on June 18, 2001 7:58 AM

Your PivotTable data can be from an external source
such as a database or text file accessed via ODBC.