Forum Discussion
Lambda function is missing on Excel Insider Beta
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.
18 Replies
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!
That illustrates what I tried to explain earlier.
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 ?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.
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.
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.
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.SergeiBaklan
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
You are not alone. Frustrating, isn't it!
Perhaps to function is part of a progressive roll-out.
