Having issues syncing my formulas created within the Advanced Formula Environment. Keep getting a "Sync names with Excel name manager failed: The argument is invalid or missing or has an incorrect format." Anyone else having this issue?

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.

Sync names with Excel name manager fails - AFE

5 Replies

PauliS
Copper Contributor
Feb 10, 2022
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.
- FerdyR
  Copper Contributor
  Feb 12, 2022
  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?
  - SergeiBaklan
    Diamond Contributor
    Feb 13, 2022
    FerdyR
    
    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.

Forum Discussion

Sync names with Excel name manager fails - AFE

5 Replies

Resources