Each PivotTableField PivotTable field must have a unique DisplayNamedisplay name. If you change the display name of a Row row or Column labelcolumn label is not the name of its source field, the display name of the SourceField source field that the label was created from will change to match the Row row or Column column label name. This only affects the display name of the SourceField source field as seen in Excel. The underlying name of the SourceFieldsource field, which is pulled from the header names of the columns in the data source, will not be affected. Changing the DisplayName for a ColumnLabel , RowLabel , or PageField will also change the displayed name for the SourceField . This is the same as the Excel behavior. This cannot be set on a ValuesLabel . The default value returned by a ValuesLabel is "Values". |