Pivot Table with multiple sheets in Excel 2000

J

Joël

Hello
I wonder if it is possible to bypass the 65k lines limit in Excel 2000 by
using more than 1 sheet when working with a pivot table !
Otherwise, I have to convert first all data in Access and then go back to
pivot table using 'external data'
Thanks for tip if any !
Joël
 
R

Roger Govier

Hi Joel

Only with XL2007, which has a limit in excess of 1 million rows.
Using multiple sheets, means using Multiple Consolidation Ranges but this
does work quite the same as with a single range.

Take a look at Debra Dalgleish's site for more information on this.
http://www.contextures.com/xlPivot08.html
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table from multiple sheets 1
Excel pivot table limitation when having Access 2
Excel 2007 vlookup with Pivot table 0
Pivot table put multiple "Values" in one row but I want them in one column. 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot Table - 2
Pivot Tables in 2007 don't work in 2003 0

Top