Forum Discussion
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...
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.
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.
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.