Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I build a pivot table from multiple worksheets which are .
I need to analyze about 60mb of data on different speadsheets in Excel. I am
attempting to build pivot tables to look at the data. How do I build pivot tables from several different worksheets in a workbook? All of the data is in columns with column headers but I can't seem to get it to pivot correctly to give me the results I need. Please help... |
#2
|
|||
|
|||
If you create a Pivot Table from multiple consolidation ranges, as you
discovered, you won't get the same pivot table layout that you'd get from a single range. There's an example he http://www.contextures.com/xlPivot08.html If possible, store your data in a single worksheet, and you'll have more flexibility in creating the pivot table. Richard Stephens wrote: I need to analyze about 60mb of data on different speadsheets in Excel. I am attempting to build pivot tables to look at the data. How do I build pivot tables from several different worksheets in a workbook? All of the data is in columns with column headers but I can't seem to get it to pivot correctly to give me the results I need. Please help... -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
How do I build pivot tables from several different worksheets in a
workbook? Sheets in question:- - All identical in structure, especially Columns & Headers, albeit number of records in each may vary? - What ranges are to be included from each sheet, eg Cols A:K? - Any other data outside those ranges? - Assuming data starts in say Col A, is it safe to assume that every cell in the range in Col A will have a value in it - If not then can any of the columns be relied upon to have data in every cell. - Headers all on same row? - Any other sheets in the workbook that are not to be counted? - If so then how do you identify the ones to use? - How many sheets approx, and how many records between them all (just approx) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Richard Stephens" <Richard wrote in message ... I need to analyze about 60mb of data on different speadsheets in Excel. I am attempting to build pivot tables to look at the data. How do I build pivot tables from several different worksheets in a workbook? All of the data is in columns with column headers but I can't seem to get it to pivot correctly to give me the results I need. Please help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |