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, some instances of the formulas work while other throw a #VALUE! error. If I open Excel Labs and simply press the floppy save icon, everything works again. But it requires going to each lambda to press the floppy save icon.
Has anyone else experienced this behavior or know how to fix it?
Yes, I experience this all the time. I often have to edit the lambda formula (add an arbitrary space somewhere) and then save. That usually works, but sometimes it does not. If it doesn't I shut down all Excel windows, check the Task Manager to ensure Excel is really not running (kill it if it is), and then reopen the file. While more of a pain, that too seems to work. However, some days, neither of these work.
Lastly, I am trying the macro approach shown here [see Mohit Bhatia2's post]:
It works for me but today is Day 1 😐
i have not and kinda weird that would happen. and you are sure you saved the workbook after doing a save on the labs? Can you attach a sample workbook showing this behavior?
Thank you m_tarler. When I get a moment to strip out confidential info, I can provide a sample.
What I've learned, and this is weird, is that a lambda variable defined as word_word is someone being changed to word_Word (the second W capitalized). When I change the variable back to lower case and press save, it all works again. When I close, sometimes it reverts it back to the old state. Sometimes it doesn't. It isn't easy to replicate the error consistently.
