When I crate a PivotTable using two spreadsheets as the source data, the field names from the spreadsheet data are not on the PivotTable toolbar. The only field names are Row, Column, and Value. The spreasheets have the same format.
How do I build the table and have the field names available on the toolbar so I can manipulate the data as if I was only using one spreadsheet as the data source.
How do I build the table and have the field names available on the toolbar so I can manipulate the data as if I was only using one spreadsheet as the data source.