You cannot create a PivotTable in Excel 2013 when field names in a source range contain similar characters


Consider the following scenario:

  • You have two field names in a source range that have similar characters. For example, one field is named "Hello2World," and the other field is named "Hello2World." The "2" character corresponds to the "178" character in ASCII.
  • You try to create a PivotTable by selecting the source range in Microsoft Excel 2013.
  • You select the Add this data to the Data Model check box in the Create PivotTable dialog box.

In this scenario, you receive the following error message:

We couldn't get data from the Data Model. Here's the error we got: 

The attribute with the name of Hello<sup>2</sup>World already exists in the '**Range**' dimension.


This issue occurs because the data model cannot differentiate between the similar characters.


To work around this issue, change one field name to be distinct from the other.


This is a known issue in Excel 2013.