want to do piovt table, where rows over 100,000

[sokevin]

Hi..

i have around 100,000 rows of data...

of cousres the worksheet i can only put 66000 or so rows per sheet.

i want to do a pivot table that combines the two sheets.

how can i do this?

thank

 

[Frank Kabel]

Hi
if you have that many data I would suggest you store this data in a
real database (e.g. MS Access). With Excel's pivot table wizard you can
then access this database as datasource.
Another way would be to split the data in two worksheets and within the
pivot table wizard choose the 'non contigenous ranges' for the data
source

 

[sokevin]

u mean do "multiple consolidation range"


i neva noticed that :

 

[Frank Kabel]

Hi
yes
not having my english Excel version on this laptop...