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

M

mfox

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)
 
H

Hans

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

Additional columns for Pivot table 0
Excel 2007 pivot table using analysis services cube as data source 0
Excel 2007 vlookup with Pivot table 0
Adding to an existing Pivot Table 7
Dynamic data ranges in pivot tables 3
about pivot table 1
Excel 2007 pivot table source table 1
How to combine two column labels in a pivot table 1

Top