Forum Discussion
LAMBDA formula not available
I' am a 365 subscriber. Windows 10 user all up to date. I deleted my current install of office and reinstalled a 64 bit ver with the correct ver of office 16.0.13426.203308. yet LAMBDA doesn't show up as a function. Any ideas?
Office tells me i have ver. 2011 (build 13246.20308)
48 Replies
davidfehr same issue for me , i have updated as per guidance but still it is not solved
If you are
1) Office 365 subscriber
2) You are Office Insider
3) As Office Insider you installed Beta channel build
4) In File->Account you see that all above is correct
lambda shall be available.
The only if that is fresh install you may wait day or two before it appears. Assuming from time to time you are with internet connection and reboot Excel.
Looks very strange. I have the same system, but all is okay
That how it works. Practically all insiders have the same build, but not all have lambda.
This functionality is available only for Office Insider , current build is
Version of Win doesn't matter if it is not too old.
However, new functionality covers only 50% of insiders, even if you install above build don't warranty you have lambdas. Kind of lottery.
- Finally I find an answer, thanks for the info! I asked for online support twice, to no avail - the second time I uninstalled and reinstalled everything (well, they did, remotely).
From MS Blog
Availability
Lambda function is available to users running Insider builds on Windows and Mac.
- Windows: Beta Channel Version 2012 Build 13519.20000 or higher.
- Mac: Beta Channel Version 16.45 Build 1201.0 or higher.
We typically release features over some time to ensure that things are working smoothly. This is true for Insiders as well. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as Insiders, have had the opportunity to try them.
I have the following build, but have no access to new LAMBDA function. Please advise why LAMBDA is not available to me? Thanks.
That is exactly as in citation
We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders.
If you have proper build number that only means lambda code is included into this build, but that doesn't mean lambda functionality switched-on. Office 365 is subscription model, this or that functionality could be switched on/off online, without the build reinstalling.
Lambda, as any new functionality, usually covers not more than 50% of insiders when announced. After that it's "slowly releasing" to other insiders. Nobody, includes Microsoft, knows how long it could be. Usually few weeks, but depends on situation, and in theory it could be switched off for all insiders, includes ones who already had new functionality. But that happens quite seldom.
SergeiBaklan WOW! great system they have created, make me wish there was an alternative...OH WELL
Thank you for the info
- Please check whether the workbook / worksheet is from Microsoft 365 or older.
NikolinoDE I in fact downloaded a workbook that had used the LAMBDA function and it didn't show only gave a #NAME? ref error where the function was used
A few pieces of information, maybe this will help you:
Note: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.
If necessary update Windows to the latest version
Announcing LAMBDA: Turn Excel formulas into custom functions
LAMBDA function
=LAMBDA([parameter1, parameter2, …,] calculation)
Announcing LAMBDA (microsoft.com)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- Correction: This functionality is available ONLY for Office Insider, as of 02/06/2022. Just as our friend SergeiBaklan stated below.
So this function is still not available and in beta for 2 years? At this point will it ever be included in the general release?
NikolinoDE My office version 2012 (build 13530.20376) but i am not getting Lambda function .....kindly suggest what to do.
What is your channel?
If Beta, I assume it shall appear with the second wave. Otherwise you shall to wait more.
NikolinoDEI did update to the most current windows and It still didn't work, however i learned it's only available to certain people, and I'm not one of those, wish I hadn't update to this stupid subscription crap
Thank you for your help
I didn't know either, thanks to Mr Baklan I now know too.
But what I know about Microsoft is that if the insiders have it now,
they will refine it and soon the rest of the Microsoft population will have it too :).
I am full of confidence when it comes to LAMBDA functionality.
I think this is the next step in evolution for the Excel formulas.
With your permission, believe that you, me and everyone else are on the right track
...but with some things in life, patience can be a virtue.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
