Forum Discussion

Copper Contributor

Dec 07, 2020

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 u...

Formulas and Functions

Copper Contributor

Feb 06, 2022

Correction: This functionality is available ONLY for Office Insider, as of 02/06/2022. Just as our friend SergeiBaklan stated below.

Copper Contributor

Feb 09, 2022

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?

mtarler
Silver Contributor
Feb 09, 2022
This just recently got released to current channel so try to force an update, that is what worked for me.
- DKoontz
  Iron Contributor
  Feb 10, 2022
  mtarler
  
  Hi, how were you able to force an update? About shows I'm on the latest build and current channel but when I go to update, office tells me I'm on the latest version.
  I'm so excited to try it out, thanks!
  - SergeiBaklan
    Diamond Contributor
    Feb 10, 2022
    DKoontz
    
    That's the latest build Release notes for Current Channel releases - Office release notes | Microsoft Docs and most probably code with new functionality is already within it. It may appear while you are working; or after next reboot; or with next update. Very soon or within few weeks. That's how deployment works.
SergeiBaklan
Diamond Contributor
Feb 09, 2022
CareySmithDuke

It is already added to current channel https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambdas-to-production-and-advanced-formula/bc-p/3138594#M2525 deployment could take up to month or two.

If you are on semi-annual channel - afraid another year to wait or so.

Resources