how do I create Excel pivot table with over 65,535 lines of data?

G

Guest

Without resorting to MS Access, does anyone have suggestions on how to take
two or more worksheets to create a pivot table? I've tried:
-naming ranges with the multi-sheet data
-'multiple consolidation ranges' in the Pivot Table wizard, but I don't get
control over the data fields, only fields named "row", "column", "value", and
"page".

Using Excel 2002 (XP)
 
G

Guest

Hi how about trying Corel's Quattro Pro, it supports up to 1.000.000 rows and
does exactly that.
 

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

Pivot using 250,000 rows of data in Excel? 1
pivot table multiple consolidation ranges 3
Pivot Table 2
Pivot Table - include multiple worksheets with different ranges. 1
Multiple Pivot Tables from Same data source 1
about pivot table 1
Pivot Table: Mult Consolidation Ranges 2
Pivot Table Data Source 1

Top