Excel: pivot from large data

K

karrie

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

Start creating your PT, then use multiple consolidation ranges and
specify the ranges from each worksheet.

--JP
 
R

ryguy7272

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--
 
Top