Register
Ask the Community

Excel add-in, Date time settings

Excel add-in, Date time settings

Status: Your support is needed Submitted by Certified Master Anaplanner on ‎09-09-2020 04:15 AM
3 Comments (3 New)

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. 

3 Comments
MagaliP
Community Boss
Community Boss
‎09-11-2020 08:37 AM
‎09-11-2020 08:37 AM

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

Kudiarasu
Certified Master Anaplanner
Certified Master Anaplanner
‎09-13-2020 11:11 PM
‎09-13-2020 11:11 PM

Hi @MagaliP 

 

I have raised a case # 00318336

 

Thanks

Kudi

RicEnq
Occasional Contributor
‎11-03-2020 07:43 AM
‎11-03-2020 07:43 AM

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.