Regional formatting and linked tables

Question

I have created a PowerPivot sheet with data from a cube. Now i want to join them with with a table i created in excel by using the linked table button. But I have set my computer to the dutch international settings, meaning the decimal seperator is a , sign and not a . sign as in english. When i load my data to PowerPivot the decimal is added to the value ignoring the dutch decimal sign.

When i put my language options to US english it works ok.

Looks like a bug to me ?

Answer 1

We are looking into this and will get back to you as soon as we have some update for you. Thank you for reporting this issue to us.

Lisa

Answer 2

This is indeed a confirmed bug and has been addressed in RC0 ( the next release after Nov CTP). Please let us know if you have any further question or comment on this.

Thank you!

Lisa