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

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
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
Multiple Pivot Tables from Same data source 1
Dynamic data ranges in pivot tables 3
Excel 2007 pivot table source table 1
Pivot tables - memory issues - please help 2
about pivot table 1
VBA Pivot Table help with data fields 3
How can I change the source data reference to another pivot table? 2

Back
Top