Consolidated pivot tables

[Guest]

Hi

I have a workbook, with 2 worksheets that have the same headings in row 1. They are then populated with information. I want to create a pivot table that will treat both the worksheets data as one list. I though thats what option 3 in the pivot table wizard "Multiple consolidation ranges" was. But when I get to the actual design part (step 3), the only fields on the right are row, column, value and page 1. None of the headings appear, as they would if I was basing the table on one worksheet
Am I doing something wrong

Thanks :->

 

[Debra Dalgleish]

You can create a PivotTable from multiple consolidation ranges, but you
won't get the same pivot table layout that you would from a single range.

If Date is the first column in your data source, the row heading should
show the dates. The column area will show each of the remaining
headings. You can change the function that's being used by the data
value, but it will use the same function on all these columns.

The PivotTable would contain some meaningless data, such as Sum of
Order# or columns full of zeros for database columns that contain text.
To avoid this, you can rearrange your database columns, and then use
data ranges that only include the columns that you want to total.

If possible, store the data on the same worksheet, or in one table in a
database, such as Access, and use that as the source for the PivotTable.