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