Pivot tables

R

Ricki Miles

I am working in version 97. Is it possible to create a pivot table that
uses two data ranges from separate worksheets if their combined data is
greater than 65,536 rows?

TIA

Ricki
 
D

Debra Dalgleish

You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a database, such as MS Access, and
you'll have more flexibility in creating the pivot table.
 
Top