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

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

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