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...
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]:
https://answers.microsoft.com/en-us/msoffice/forum/all/lambda-custom-formulas-randomly-breaking/304df348-e4bc-4d78-98cc-ce8b782cb569
It works for me but today is Day 1 😐