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

S

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
 
F

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
 
Top