PivotTable

Hi,

I have a pivottable and in two fields excel put a 2 after the fieldname.
sonmicAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

column headers (field names) must be unique in a pivot table source. If you have two data columns with the same name, Excel will MAKE them unique by adding a number at the end.

cheers, teylyn
0
 
helpfinderIT ConsultantCommented:
probably better would be to attach the mentioned file or create a sample with the same problem if original file is confidential
0
 
LazyFolkCommented:
is the fieldname already used somewhere in the workbook ?
0
All Courses

From novice to tech pro — start learning today.