Pivot Table Using Multiple sources

[td]

I am trying to build a pivot table using more than 1
file/worksheet. The files have the same column
headings. I can not combine the 2 files as Excel 2002
limits the worksheet to 65535 rows.

Any suggestions?

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.

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