Forum Discussion
LAMBDA formula not available
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.
- 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.
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.
Sergei:
Thank you for your response. All the requirements are met and I am running Excel 2108 (14315.20008) and no LAMBDA.
I appreciate your assistance.
- I assume you have already had Excel look for updates, so...
Try this:
- Reboot your computer
- Open Excel
- Open task manager and kill the Excel.exe process from the "Details" tab
- Now open Excel again. Hopefully you now have that LAMBDA function.It will be nice if it works, but we discussed an option to wait couple of days and reboot in between.
I'll try to check. Is that Home subscription ?
