Forum Discussion

Carlos Spörk's avatar
Carlos Spörk
Brass Contributor
Jan 03, 2022

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.

  • JKPieterse's avatar
    JKPieterse
    Jan 07, 2022

    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.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    LAMBDA is only available for Office insiders, have you switched channel or turned off insiders by any chance?
    • Carlos Spörk's avatar
      Carlos Spörk
      Brass Contributor
      Hello Jan, I haven't switched the channel. I actually checked my account in Excel and I am still on the Current Channel (Preview).

Share

Resources