PivotTable Multiple Consolidation Ranges

RayD · Apr 18th, 2002, 10:32 AM

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. · Apr 18th, 2002, 12:10 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 10:32 AM	#1
RayD New Member Join Date: Apr 2002 Posts: 2	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?

Apr 18th, 2002, 12:10 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]