Forum Discussion

Eppes_A_Yungeman's avatar
Eppes_A_Yungeman
Copper Contributor
Apr 18, 2022
Solved

LAMBDA bug

In https://docs.google.com/spreadsheets/d/1nhvRtEMB_KCU3otIwkouwLI-_2PpQNX0/edit?usp=sharing&ouid=112582939807587240769&rtpof=true&sd=true (it won't calculate properly in google drive) I created a LA...
developer
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 18, 2022

    Eppes_A_Yungeman 

    We can't use for naming Excel 4.0 Macro Functions names, they are reserved. PARSE is one of them. You may try with BEEP, OVERLAY,... - lot of them. Same result.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 18, 2022

Eppes_A_Yungeman 

We can't use for naming Excel 4.0 Macro Functions names, they are reserved. PARSE is one of them. You may try with BEEP, OVERLAY,... - lot of them. Same result.

Eppes_A_Yungeman's avatar
Eppes_A_Yungeman
Copper Contributor
Apr 26, 2022
Shouldn't the name manager prevent you from using a name that is reserved? This would only be an issue with LAMBDA which works as a formula once it's named and not with other types of names.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 26, 2022

    Eppes_A_Yungeman 

    Name Manager was done in previous century, it has many things to be updated. Perhaps one day we will have new modern one. Afraid these are global changes.

    That is not only for lambdas, for any function we generate (e.g. with VBA). Perhaps Advanced Formula Environment add-in will work with reserved names when in production. Not now.

    Plus cross-platforming. We may use reserved names in Excel for web, but it gives an error if we open such file in desktop version.

    Hope Microsoft will solve that one day, but that's not easy task from my point of view.

Resources