LAMBDA

Hello guys

I have installed the prepaid package office 365 Family, I am logged in the insider program current (preview), version 2109 (14430.20234) and I do not see the LAMBDA function in Excel. Why?

Check for updates and install any available updates to ensure that you have the latest version of Excel.

You should also ensure that you are logged in to the correct account. Make sure that you are logged in to the account associated with your Office 365 Family subscription. This is because the LAMBDA function may only be available for certain types of subscriptions, and you need to be logged in with the correct account to access it.

Another thing to check is if the LAMBDA function is enabled in Excel Options. To do this, go to File > Options > General > Preview features and check if "Enable optional connected experiences" and "Show preview features" are selected. If not, select these options and see if the LAMBDA function appears.

If none of these steps work, you may need to wait for the next update to Excel to see the LAMBDA function. It may not be available in the current preview version that you are using, and you may need to be patient and wait for the next update.

If still this issue isn't resolved, I would encourage to connect to the Microsoft Support for further assistance.

Lambda was released to Insiders in Dec 2020.

https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/

.

This article written in Aug 2021 says it is still in Beta/ Insider https://www.infoq.com/articles/excel-lambda-turing-complete/

.

When do I get new Features https://support.microsoft.com/en-us/office/when-do-i-get-the-newest-features-for-microsoft-365-da36192c-58b9-4bc9-8d51-bb6eed468516 .

Short form, users have no control, you'll get it when you get it, when ever MS feels like giving it to you. There is no magic incantation you can use to get it sooner ...

.

You can get new features earlier if you join the Insiders program.

.

General Lambda links:

https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67 . https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546 - Lambda (beta) release Dec 2020.

https://www.fm-magazine.com/news/2021/feb/new-excel-function-lambda-formula-building.html 

. https://www.myonlinetraininghub.com/excel-lambda-function