Forum Discussion
Sync names with Excel name manager fails - AFE
I found the solution for this. The cause is the formula separator in my Excel. It uses semicolon (;) by default as a separator in formulas. Changing the separator in Excel Options fixed this.
There are no issues with import and the AFE when Excel uses comma.I hope the AFE will be changed to support other formats also, just like the formulas in Excel do.
Hi PauliS ,
I run into the same error trying out a LAMBDAS formula in the AFE. However the solution of changing the list separator in the options did not work out for me. I also tried to change the list separator in my Regional settings, without result. Do you know how I could fix this?
What documentation says
We currently only support one locale where , is the argument separator and ; is the name assignment separator. Localization feature requests can be tracked under Issues.
https://github.com/microsoft/advanced-formula-environment
IMHO, it's more effective to communicate related to AFE issues directly on GitHub.
SergeiBaklan, thank you for your response. I agree that Github is the way to go for issues. But in my case the cause seems to be in the settings:
Changing the list separator from ; to , in my Windows Region settings and changing my Office from Dutch to English made my AFE formulas work in the end.
Best regards,
Ferdy
I had the same issue on my MacBook (UK English but with Swiss keyboard).
Preferred language is English (UK).
To fix:
System Preferences -> Language&Region -> Apps and I added Excel English (Not English UK).
Imported lambdas work ok, just not able to create new ones.
