Excel add-in, Date time settings

Excel Add-In error: Refresh failed due to unexpected error.

Found out that when the Excel template is created with Regional settings [ ex. decimal symbol as Dot / . ] is different from your system settings [ ex. Decimal symbol Comma / , ]  then the refresh fails and shows up unexpected error.

 

Kudiarasu_0-1599642794587.png

This is solved as soon as the Changes are made in Control Panel > Change Date Time Settings > Additional Settings.

 

Hope this is resolved in future releases. 

1
1 votes

New · Last Updated

Comments

  • @Kudiarasu - could you please raise this with Anaplan Support so we can investigate? Thank you

  • Hi @MagaliP 

     

    I have raised a case # 00318336

     

    Thanks

    Kudi

  • Kudoed! This issue is hindering us from doing a full rollout of the Excel plugin.

    From testing, the only region settings that work for us is English US or English UK. Would be great if the region setting of the computer did not affect the plugin at all.

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!