Forum Discussion
Carlos Spörk
Jan 03, 2022Brass Contributor
LAMBDA function not supported anymore?
Hello, I am signed up for the Office Insider Current Channel (Preview) and currently have version 2111 build 16.0.14701.20240 installed. As soon as the LAMBDA function was released for Office...
- Jan 07, 2022
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
Jan 05, 2022Brass Contributor
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.
JKPieterse
Jan 06, 2022Silver Contributor
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.
- Carlos SpörkJan 06, 2022Brass ContributorFunny thing is, the function works just fine when I open any of the workbooks using the LAMBDA function in Excel for Android.
- JKPieterseJan 07, 2022Silver Contributor
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.
- Andrew_HoweFeb 03, 2022Copper Contributor
Just to say this is (probably) what happened to me; my son took me through a move from gmail to Outlook, which involved setting up a different (personalized) email address, to which I had to transfer my Office365 subscription. I then found - quite by chance - that the lambda functionality had disappeared.
I immediately:
* subscribed (with the new email account) to the office insider programme
* did an online repair of office
... but have not yet got lambdas working
I am hoping that they "come back" with a future update.
Curiously (to my simple mind) MS first line tech support gave up and wouldn't refer me further to technicians, instead giving me a number of community links (which led to this). My hopes rather fell when the person taking over my machine seemed really confused about my customized ribbon 🙂
Best wishes
Andrew Howe
- Carlos SpörkJan 06, 2022Brass Contributor
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!
- JKPieterseJan 07, 2022Silver Contributor
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örkJan 27, 2022Brass Contributor
JKPieterse Well, after waiting for almost 3 weeks I've got the latest update for the Current Channel (Preview) and lo and behold, the LAMBDA function is back, and all of my workbooks are working again. Before that, I had already followed your suggestion to sign out of my other 365 accounts.
Thank you so much for your help!