K karrie Oct 1, 2009 #1 I have data of more than 66000 rows in more than one sheet with same column headings. Can I combine them to form a single pivot table?
I have data of more than 66000 rows in more than one sheet with same column headings. Can I combine them to form a single pivot table?
J JP Oct 1, 2009 #2 Start creating your PT, then use multiple consolidation ranges and specify the ranges from each worksheet. --JP
Start creating your PT, then use multiple consolidation ranges and specify the ranges from each worksheet. --JP
R ryguy7272 Oct 1, 2009 #3 Yes, of coures. A source for a Pivot Table could be an Access DB, SQL Server, etc. You could conceivable have millions or rows, which may consolidate to just a few thousand rows, or maybe even a few hundred rown, in an Excel Pivot Table. Look at these examples http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/ http://peltiertech.com/Excel/Pivots/pivottables.htm A little more advanced: http://office.microsoft.com/en-us/excel/HP051993041033.aspx http://www.associatedcontent.com/article/295956/creating_a_pivot_table_from_an_external.html?cat=59 HTH, Ryan--
Yes, of coures. A source for a Pivot Table could be an Access DB, SQL Server, etc. You could conceivable have millions or rows, which may consolidate to just a few thousand rows, or maybe even a few hundred rown, in an Excel Pivot Table. Look at these examples http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/ http://peltiertech.com/Excel/Pivots/pivottables.htm A little more advanced: http://office.microsoft.com/en-us/excel/HP051993041033.aspx http://www.associatedcontent.com/article/295956/creating_a_pivot_table_from_an_external.html?cat=59 HTH, Ryan--
