Pivot Table - Multiple Worksheets

[Emyn]

Hi,

I have two spreadsheets in separete workbooks containing various types
of differing data under different column headings. I would like to
anaylse the data contained within the spreadsheets using 1 Pivot
Table.

I have tried using the Pivot Table wizard and opting for Multiple
consolidated ranges, however, this still only lets me look at data from
1 workbook at a time and does not allow me to analyse data from both
workbooks at the same time.

Is there anyway I can do this?

Thanks

Emyn

 

[Debra Dalgleish]

A pivot table based on multiple consolidation ranges assumes that the
ranges have identical layout. Even then, you won't get the same pivot
table layout that you'd get from a single range. There's an example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a single worksheet, or in a database,
and you'll have more flexibility in creating the pivot table.