PivotTable Multiple Consolidation Ranges

[RayD]

When I create a PivotTable from two spreadsheets with the same format, the PivotTable toolbar does not have the field name from the data. The only field names that appear are Row, Column, Value.

Is there a way to do this and see the field names that usually appear when you create the table using a single spreadsheet?

[Mark W.]

Not unless you rename the Row, Column and Value field buttons yourself.

[ This Message was edited by: Mark W. on 2002-04-18 11:13 ]