In a PowerPivot workbook, when numeric values are converted to strings, the result is different values in different locales when linked tables are updated

• You create a Microsoft PowerPivot workbook on a system whose locale is, for example, <XLocale>.
• This PowerPivot table has a linked table that has a text column, and this column contains numeric data.

In this scenario, if you open and update this table on a system whose locale is <XLocale>, all the values are displayed correctly. But if you open it on a system whose locale is different, such as <YLocale>, you notice that the numeric values are displayed differently. This problem occurs because the numeric values are converted to strings that use the current system locale.

For example, see the scenario that describes this problem in the "More Information" section.

Back to the top

Microsoft is researching this problem and will post more information in this article when the information becomes available.

Back to the top

  For more information about this scenario, see the following example:

1.    On a US English operating system, create a PowerPivot workbook that has Decimal, DateTime, and Text values in a single column. For example, the workbook column contains the following values:  

o   Decimal = 1.1

o   DateTime = 01/02/2003 12:00:00 AM

o   Text = text

2.    Open this workbook on a system whose locale is Russian, and then click Update All to update all the linked tables. The sample data in the workbook column in PowerPivot is changed to the following values:

o   Decimal = 1,1

o   DateTime = 02.01.2003 0:00:00

o   Text = text

Back to the top