Lambda function is missing on Excel Insider Beta

%3CLINGO-SUB%20id%3D%22lingo-sub-1959448%22%20slang%3D%22en-US%22%3ELambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959448%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20signed%20up%20for%20Beta%20Channel%20and%20have%20all%20the%20other%20functions.%20I%20have%20been%20getting%20the%20new%20functions%20right%20away%20as%20soon%20as%20I%20do%20the%20update%20for%20years%20but%20even%20though%20I%20have%20the%20latest%20version%2C%20I%20still%20do%20not%20have%20the%20Lambda%20function.%3C%2FP%3E%3CP%3EAny%20ideas%20why%3F%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-12-05%20111823.jpg%22%20style%3D%22width%3A%20875px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238013i88DCC61B6A270518%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-12-05%20111823.jpg%22%20alt%3D%22Screenshot%202020-12-05%20111823.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1959448%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959469%22%20slang%3D%22en-US%22%3ERe%3A%20Lambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409318%22%20target%3D%22_blank%22%3E%40Ers_Siv%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20not%20alone.%26nbsp%3B%20Frustrating%2C%20isn't%20it!%3C%2FP%3E%3CP%3EPerhaps%20to%20function%20is%20part%20of%20a%20progressive%20roll-out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959559%22%20slang%3D%22en-US%22%3ERe%3A%20Lambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959559%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20read%20it%20online%2C%20looked%20like%20everyone%20got%20it%20but%20me.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3ECant%20wait.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EErsin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1966777%22%20slang%3D%22en-US%22%3ERe%3A%20Lambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1966777%22%20slang%3D%22en-US%22%3EThough%2C%20I%20have%20the%20LAMBDA%2C%20you're%20not%20the%20only%20person%20that%20haven't%20gotten%20the%20function%20yet.%20Flighting%20on%20Beta%20Channel%20is%20usually%20the%20first%2050%25%20lucky%20subscribers.%20It%20takes%20some%20time%20for%20it%20to%20get%20to%20100%25%20flighting%20to%20Beta%20Channel.%20Then%2C%20it%20takes%20another%20time%20to%20light%20to%20Current%20channels%20etc%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1996629%22%20slang%3D%22en-US%22%3ERe%3A%20Lambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1996629%22%20slang%3D%22en-US%22%3E%3CP%3Ewhat%20new%20installed%20says%20about%20lamda%26nbsp%3B%3C%2FP%3E%3CP%3Ehowever%20I%20cannot%20use%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1998994%22%20slang%3D%22en-US%22%3ERe%3A%20Lambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1998994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F409318%22%20target%3D%22_blank%22%3E%40Ers_Siv%3C%2FA%3EHello%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20know%20if%20you%20have%20any%20update%20on%20that%20because%20I'm%20facing%20the%20same%20issue.%3CBR%20%2F%3EIf%20I%20look%20at%20this%20link%20it%20says%20that%20the%20function%20should%20be%20available%20for%20every%20build%20starting%20from%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EWindows%3A%20Beta%20Channel%20Version%202012%20Build%2013519.20000%20or%20higher.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2Fblog%2Flambda-excel-custom-functions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Finsider.office.com%2Fen-us%2Fblog%2Flambda-excel-custom-functions%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20if%20I%20look%20at%20this%20to%20understand%20builds%20versionning%20%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fupdate-history-beta-channel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fupdate-history-beta-channel%3C%2FA%3E%3C%2FP%3E%3CP%3ESounds%20like%26nbsp%3B%3CSPAN%3EVersion%202101%20(Build%2013610.20002)%20is%20the%20most%20recent%20build%20there%20is%20and%20it's%20the%20one%20I'm%20having.%3CBR%20%2F%3EStill%20I%20don't%20have%20an%20access%20to%20the%20Lambda%20function.%3CBR%20%2F%3EAm%20I%20missing%20something%20%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1999002%22%20slang%3D%22en-US%22%3ERe%3A%20Lambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999002%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F905485%22%20target%3D%22_blank%22%3E%40MBourgeois%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20proper%20build%20that%20only%20means%20the%20code%20for%20the%20lambda%20functionality%20is%20included%20in%20that%20build.%20But%20that%20doesn't%20mean%20this%20functionality%20is%20switched%20on%20for%20you.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20to%20simplify%20that's%20like%20with%20corporate%20credit%20card.%20If%20you%20have%20one%20that%20means%20you%20have%20access%20to%20some%20bank%20account%2C%20but%20that%20doesn't%20mean%20that%20your%20employer%20put%20money%20on%20this%20account.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1999026%22%20slang%3D%22en-US%22%3ERe%3A%20Lambda%20function%20is%20missing%20on%20Excel%20Insider%20Beta%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999026%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20Thank%20you%20for%20the%20quick%20reply.%3C%2FP%3E%3CP%3EJust%20for%20the%20record%20I'm%20working%20as%20a%20Freelance%2C%20and%20I%20would%20not%20let%20myself%20turn%20short%20of%20money%20on%20the%20bank%20account%20associated%20with%20my%20corporate%20credit%20card%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am signed up for Beta Channel and have all the other functions. I have been getting the new functions right away as soon as I do the update for years but even though I have the latest version, I still do not have the Lambda function.

Any ideas why?

Thank you.

 

Screenshot 2020-12-05 111823.jpg

18 Replies

@Ers_Siv 

You are not alone.  Frustrating, isn't it!

Perhaps to function is part of a progressive roll-out.

@Ers_Siv 

That's a lottery, first wave covers maximum 50% of insiders. When 100% of insiders nobody knows, it could be couple of weeks, could be couple of months, could be more. If you have right build that only means lambda code is inside your build, but that doesn't mean functionality is switched on. That is specific of subscription model.

Thank you.@Sergei Baklan 

When I read it online, looked like everyone got it but me.

Cant wait.

 

Ersin

Though, I have the LAMBDA, you're not the only person that haven't gotten the function yet. Flighting on Beta Channel is usually the first 50% lucky subscribers. It takes some time for it to get to 100% flighting to Beta Channel. Then, it takes another time to light to Current channels etc

In my organization every one has an update and can use lamda function

but only me still waiting

what new installed says about lamda 

however I cannot use it

@Saurabhjain23 

What's New informs about what's new on the channel (beta), not about what's new on your concrete computer. New functionality is always deployed gradually, usually on beta channel first wave covers not more than 50% of insiders. That's only to wait next one, usually few weeks, but nobody knows concrete schedule.

@Ers_SivHello,

I would like to know if you have any update on that because I'm facing the same issue.
If I look at this link it says that the function should be available for every build starting from 

  • Windows: Beta Channel Version 2012 Build 13519.20000 or higher.

https://insider.office.com/en-us/blog/lambda-excel-custom-functions

 

Now if I look at this to understand builds versionning :

https://docs.microsoft.com/en-us/officeupdates/update-history-beta-channel

Sounds like Version 2101 (Build 13610.20002) is the most recent build there is and it's the one I'm having.
Still I don't have an access to the Lambda function.
Am I missing something ?

@MBourgeois 

If you have proper build that only means the code for the lambda functionality is included in that build. But that doesn't mean this functionality is switched on for you. 

If to simplify that's like with corporate credit card. If you have one that means you have access to some bank account, but that doesn't mean that your employer put money on this account.

@Sergei Baklan Thank you for the quick reply.

Just for the record I'm working as a Freelance, and I would not let myself turn short of money on the bank account associated with my corporate credit card

@MBourgeois 

That's easier, but here we don't code lambda functionality for ourselves.

@Sergei BaklanAnd that is my point, if they give you a credit card, what not put the money in it as well. If you wont, dont give the credit card then.

What is the purpose of rolling it out gradually among Beta users. Obviously Beta users wants to try things ahead of time and give you feed back. Why not give them all access at once.

Anyways, MS is dropping the ball on some of it's Excel functionalities lately, bigtime.

@Sergei Baklan 

It is extraordinarily frustrating though.  I wasn't able to recommend dynamic arrays for financial modelling because accumulations and row sums become a mess of MMULTS and SUMIFS if you want to make the entire model dynamic.  I even got as for as proposing a function on UserVoice, which would iterate over selected array variables without involving them in aggregation or pairwise lifting.

Implement a FOR.EACH operator to pipe values from an array into a formula one by one – Welcome to Ex...

 

Now the LAMBDA function appears to do the job with some elegance.  I think I can write a formula for accumulation with variable interest rates and adjustments to impose limits on the balance.  I have examples with multidimensional arrays where the recommended solution is to normalise the data and use SUMIFS.  I think the recursion available from LAMBDA will allow me to work with the more natural 4D array of 'units sold'.  I had set some time aside to refactor the solution workbooks but I am left, knowing the functionality exists on my machine, but I can't access it!

 

For most developments, I am quite content to wait for an incremental rollout but dynamic arrays, LET and now LAMBDA do not fall into that category.  I wish I had a way of overriding the rollout lottery; after all, I would never paid for an Office subscription had it not been for this functionality.

@Peter Bartholomew , I hope I understand your point, but what can we do, that's the model which Microsoft uses. Even being an MVP or participating in other programs, in addition to insiders, in many cases doesn't give the warranty you receive new functionality first. MVP only have information, which is under NDA, some earlier than other users, but receive (or don't receive) new functionality on the same basis as other insiders.

My approach - I have 3 beta installations under the same account on different (includes virtual) machines, at least one of them usually wins the lottery. Or that could be few different MSA accounts using same machine, also could help.

I guess you'd like me to transfer your point to Microsoft - believe me, they know. Perhaps one day that will be improved, but that's not as easy as flick the switch. And that's not Microsoft Excel team responsibility, at least directly.

I am missing Lambda on one laptop and have it on another.  Both PC's look to have the same license info, both up to date on Beta Channel, and have version 2101 (13617.20002 Click-to-Run) Beta Channel.

 

I don't get it!

@RonBayley 

That illustrates what I tried to explain earlier.

I@Sergei Baklan 

Yes now i got it

my first video on same

Using Lambda & Recursive Lambda to create user defined custom function Excel
https://www.youtube.com/watch?v=JS8312yLfTE

Examples Covered
1 Square of a number
2 Sum of squares from 1 to N
3 Sum of digits

Discussion Link
https://bi-analytics.org/blogs/entry/54-use-of-lambda-recursive-lambda-to-create-user-defined-custom...

Tutorial Linkhttps://bi-analytics.org/blogs/entry/54-use-of-lambda-recursive-lambda-to-create-user-defined-custom-function-excel/Examples Covered1 Square of ...

@Saurabhjain23 

Yes, another wave of deployment was started, hope all insiders will have lambdas soon.

By the way, another variant for sum of digits

=LAMBDA(x, SUM(IFERROR(--MID(value,SEQUENCE(LEN(x)),1),0)))