Pivot tables

  • Thread starter Thread starter Ricki Miles
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Managing huge data base 1
Adding to an existing Pivot Table 7
Pivot Table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot tables - memory issues - please help 2
Pivot Table Data Source 1
Pivot table data source 1
Pivot table filter list - listing irrelevant subcategorys 1

Back
Top