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

Applies to: Excel 2013


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 "Hello²World." The "²" 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²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.