Multiple Consildation Ranges in a Pivot Table.

[Andrew B]

Hi,

Once again a bit of help is required. I am using Excel 97 sr2.

I have two worksheets with 5 columns in each. Both sheets have the same headings

Date / Order Ref / Order Type / Container Ref / Container Type.

There are approx 50,000 rows in each sheet.

I am trying to consolidate these two tables into one pivot table.

But I am only getting the following lables to drag an drop into place.

Page / Row / Column / Count

rather than the headings I would like Date, Order Ref etc.

Am I doing something wrong?

 

[Debra Dalgleish]

If you choose to use multiple consolidation ranges, you won't get the
same pivot table layout that you would from a single range.

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

Or, if possible, you could dump all the data into one table in a
database, and use that as the source for the PivotTable.

 

[Andrew B]

Thanks for the help Debra.

 

[papegoja]

Can anyone help me and explain how I get a Pivottable from more than one
range/sheet?

I have more than 100.000 of sales figures (rows) that I want to make a
pivottable out of.

But as we all know, Excel only handles 65536 rows. So I have to import
the data two more than one sheet.

Is this doable? I am using Excel XP.

Best regards
/Dani