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 u...
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.
When will these new functions be available on the non-Insider builds? It's been about a year since it was announced to great fanfare.
- I spoke and live chatted to MS technical support twice in the last week. The timeline for general public release is unknown.
- IMHO, only choice for users (VBA restricted by company policy) is labour-intensive naming formulas intuitive to other users; challenges i/c long names truncated by monitor width; Unicode required to emulate Excel function style.
Knowing release date of new function help cut elaboration on names. My Example: SUBSTITUTE﹙txt﹐﹛old﹜﹐﹛new﹜﹚ same as Substtitute function but array inputs; I would just choose less intuttive name.
I wish Microsoft provides VBA to emulate beta functions for earlier adoption; reluctance to change when something obsolete still works esp. when sunk cost is not small.- I also wish for Name Manager to accept Unicodes so that I can follow Excel syntax
https://techcommunity.microsoft.com/t5/excel/name-manager-accomodate-uncodes-to-follow-excel-syntax/m-p/2867714#M11881
Dan_M_328 I've had the Insider build for years, ans still don't have LAMBDA. I used to have UNIQUE and now I don't. I never had a decent answer from Microsoft.
