Forum Discussion
LAMBDA function not supported anymore?
Carlos Spörk Do you have multiple 365 accounts by any chance? If so, try signing out of all but one and then let Office update itself.
Carlos Spörk New features of Excel are "flighted", which means only part of all users in a certain channel get them. It sounds as if something went wrong during an update of Office and you lost access to this feature. You can try fully removing Office and re-installing it, hoping you get the feature back. But it is a lottery unfortunately.
Well, that behavior of functions availability on a random criteria is definitely rude. We're after all supposed to test and provide feedback on preview or beta features. And now I find out that some of the workbooks I created are probably not going to be of any use whatsoever until the LAMBDA function is released to the general public?
Btw, completely uninstalling and reinstalling Microsoft 365 only to see if I'm lucky to win the lottery would be a waste of time.
- According to what I heard, all Insiders should have access to LAMBDA now. Try Launching Excel, then killing its process using Taks manager, then launching it again. If that fails, I suggest to let it update itself. If no updates are available, I think your last straw is an on-line repair of Office.
JKPieterse Yesterday I uninstalled and reinstalled Office (after rebooting). After reinstalling, I made sure I was still subscribed to the Office Insider's Current Channel (Preview), and I already had an update available for the Current Channel. Still, the LAMBDA function is not available. I will wait for the next update. Based on what you've heard, I might get the function back with that update. Thank you so much for your help!
Carlos Spörk Do you have multiple 365 accounts by any chance? If so, try signing out of all but one and then let Office update itself.
- Funny thing is, the function works just fine when I open any of the workbooks using the LAMBDA function in Excel for Android.
Carlos Spörk I got official response about this, which comes down to:
we’ve sometimes seen people lose flighted features when they should still have those flights, some reasons are,
- they switched their channel
- they switched their account
- they upgraded / downgraded their build, or performed a clean install
- (some less common scenarios)
I know that doesn't solve your issue though.