pivot table multiple worksheet source data
 

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?

pivot table multiple worksheet source data
 

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 he

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


Rick C wrote:
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
Contextures
http://www.contextures.com/tiptech.html

pivot table multiple worksheet source data
 

On 7 Sep, 14:02, Rick C <Rick wrote:
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