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.



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 votes

New · Last Updated


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

  • Hi @MagaliP 


    I have raised a case # 00318336




  • 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!