IT Management Suite

 View Only

IT Analytics export to Excel fails when location is not United States

  • 1.  IT Analytics export to Excel fails when location is not United States

    Posted Jun 14, 2012 08:31 PM

    When exporting cube data from IT Analytics to Excel there is this error in Excel..

    XML for Analysis perser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value

    Changing the location setting on the PC running Excel to 'United State's allows the import to work. This however is not a solution as then all dates on the PC are messed up.

    Has anyone found a solution for those of us who do not live in the US?