locked
CRM 2016 On Premise export to Excel Pivot Table encoding problem RRS feed

  • Question

  • Hello,

    I face special characters encoding problem in CRM 2016 on premise when exporting to Excel Pivot Table.

    The same problem exists in both Dev and Prod environments.

    Exporting to other types of Excel (e.g. Static WorkSheet) works great.

    Error example, if text has any kind of Lithuanian characters it shows them incorrectly:

    In CRM                      -> In Excel PivotTable

    ĄČĘĖĮŠŲŪŽąčęįšųūž -> ĄČĘĖĮŠÅ²ÅªÅ½Ä…čęįšÅ³Å«Å¾

    System description:

    CRM 2016 on premise 8.0.0.1088 (without update)

    SQL 2014, database Collation Latin1_General_Cl_Al

    Tuesday, March 21, 2017 6:51 AM

Answers