XXL Pivot Table
Posted by Lukas on November 01, 2001 7:03 PM
Hi!
I have about 100'000 rows of data (2 sheets)... I wanna make a pivot table... unfortunately, it's not possible to select the data from both sheets... Do you have an idea how I can solve this problem?
thanx a lot for your help!
Lukas
Posted by Richard S on November 01, 2001 7:44 PM
The only thing I can think of is to make two pivot tables, paste as values to join them together and make a third one from the result. Depends how complex your pivot table is going to be.
Richard
Posted by Mark W. on November 02, 2001 5:29 AM
Rather than keeping all your data on 2 worksheets
combine it into a single text file and create
a PivotTable that "reads" it as an external data
source (see the 2nd option at Step 1 of 3 of the
PivotTable wizard).
