How to include a name to a lambda function in Excel 365 on OneDrive

Question

riny_van_eekelen · Answer

LHCeroni&nbsp;There's no Name Manager in the on-line version so you will have to use the "Advanced Formula Environment" on the Formulas ribbon.Click the icon, then on the Names tab and the big + sign. Fill in the Function name, the description (optional), add arguments to be used in the LAMBA and then the function itself in the definition box. Press Done.&nbsp;&nbsp;&nbsp;

naman624 · Answer

Riny_van_Eekelen&nbsp;There is no Advanced Formula Environment option either on the web version as of October 2023. Is there any sure shot alternative?

patrick2788 · Answer

Are you using the Excel web app with a work account? It could be an organizational setting where Excel Labs is not being deployed. I checked the web app just now for personal and work accounts and Excel Labs/AFE is there.

riny_van_eekelen · Answer

Naman624&nbsp;Much has changed since November last year. what used to be the AFE on its own is now stashed away under Excel Labs on the Home ribbon.&nbsp;

naman624 · Answer

Riny_van_Eekelen&nbsp;,&nbsp;@Patrick2788 I am using a personal account on OneDrive live (web version). And no, even Excel labs isn't available on the home ribbon or anywhere else&nbsp;.

Forum Discussion

How to include a name to a lambda function in Excel 365 on OneDrive

8 Replies

Resources