Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Source Worksheet and Range | Excel Discussion (Misc queries) | |||
Multiple worksheets as the source for a pivot table | Excel Discussion (Misc queries) | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |