Forum Discussion
LAMBDA function not supported anymore?
Hello,
I am signed up for the Office Insider Current Channel (Preview) and currently have version 2111 build 16.0.14701.20240 installed.
As soon as the LAMBDA function was released for Office Insiders, I created several Workbooks using LAMBDA functions in them. They all worked like a charm. However, after a few days of not using those Workbooks, I opened one of them and found a #NAME? error (unsupported function) in every single cell where the LAMBDA function was being used.
When I opened Name Manager, I found something like this (it's from one of the function's online examples):
=_xlfn.LAMBDA(_xlpm.a,_xlpm.b,SQRT((_xlpm.a^2 + _xlpm.b^2))).
The other Workbooks are showing the same issue. I closed the Workbooks without saving.
Was the LAMBDA function deprecated? I checked my account and I am still on the Current Channel (Preview) with no pending updates.
Carlos Spörk Do you have multiple 365 accounts by any chance? If so, try signing out of all but one and then let Office update itself.
21 Replies
- LAMBDA is only available for Office insiders, have you switched channel or turned off insiders by any chance?
- Hello Jan, I haven't switched the channel. I actually checked my account in Excel and I am still on the Current Channel (Preview).
Carlos Spörk New features of Excel are "flighted", which means only part of all users in a certain channel get them. It sounds as if something went wrong during an update of Office and you lost access to this feature. You can try fully removing Office and re-installing it, hoping you get the feature back. But it is a lottery unfortunately.
