Forum Discussion
Lambda Bugs
I've been using excel labs to write some longer LAMBDAs. I've noticed that lambda functions that work when they are created, arbitrary stop working when I close and reopen the file. Interestingly, so...
since you also see this behavior, can you confirm if you also have Lambda naming of the form:
name_name
and maybe further check if data_junky observation that the above name_name becomes name_Name and the cause of the problem?
m_tarler Here are the names of the lambdas I use frequently:
- FICA_calc: I do seem to have trouble with this one more frequently than the others. Maybe I'll try renaming it to remove the "_". [Note that the "calc" portion of the name has always been lower case.]
- UnPivot: This too has issues periodically. It is working on a large data range and maybe that is a factor. (Weird thing is I have a switch to turn it off--when off it is designed to return a single cell with "off"-- but when the lambda bug appears it ignores the on/off switch and processes the entire data range and returns an array of errors.) Note that I have this lambda in a separate file from FICA_calc.
- xXLOOKUP: (Does a two dimensional XLOOKUP) I don't believe I have had an issue with this one.
- DefArg: (Only used internally by my other lambdas) I don't believe I have had an issue with this one.
Its not clear to me if data_junky is saying the name changed by itself or if someone was changing it. I've never had a name change on his own. Anyway, I suspect when data_junky changes the capitalization in the name and resaves, it is equivalent to my approach of adding a random space to the lambda and resaving.