pivot table multiple worksheet source data

R

Rick C

I have a workbook with three worksheets of data. Each worksheet has about
50,000 rows. I am trying to build a pivot table that accesses data from the
three worksheets but cannot get it to work. Any suggestions?
 
I

Ian

I have a workbook with three worksheets of data. Each worksheet has about
50,000 rows. I am trying to build a pivot table that accesses data from the
three worksheets but cannot get it to work. Any suggestions?
Click to expand...

Rick,

If the three worksheets have the same coulumns of data then a UNION
query with an Excel ODBC driver can be used to "join" the three data
sets together as a single source for the pivot table.

Ian
 
Top