pivot table multiple worksheet source data

[Guest]

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?

 

[Debra Dalgleish]

You can create a pivot table from the data on separate sheets (multiple
consolidation ranges), but the results may not be exactly what you want.
There's more information here:

http://www.contextures.com/xlPivot08.html

 

[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?

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