Forum Discussion
Excel 365 LET Function not recognized
Hi,
I just upgraded to Office 365 ProPlus
The LET function is not available.
Does anybody know how to fix this issue?
\Thank you
Most probably you are on semi-annual channel, if so update on Current one.
9 Replies
Most probably you are on semi-annual channel, if so update on Current one.
Does this also apply to Microsoft Office Professional Plus 2021?
Because I cannot get the LET command to work; however, it works on my company laptop that has Microsoft Office 365 Pro Plus.
Does the LET function just not work on Microsoft Office Professional Plus 2021!? 😲
It shall be available for 2021 LET function - Microsoft Support
Under "not work" what exactly do you mean - you can't find it among other functions (on ribbon Formulas->Logical->LET), or you have some kind of error using it; or something else.
If you check File->Account what is exact version of your Excel?
SergeiBaklan If on a semi-annual enterprise channel then likely I cannot switch or update on the current one ?
Is there any other way to get this feature ? It would be extremely helpful with my work but it would be near impossible to have our admins change anything in this space.
Thanks in advance.
GavHow to change the channel is here https://docs.microsoft.com/en-us/deployoffice/change-update-channels That's only IT administrator could change it; or you may change yourself if you have administrative rights on your machine and that's not against your organization policy.
And there are 3 versions of semi-annual enterprise (1908, 2002 and 2008, latest is exists with preview). Not if LET() is on some of it, you may check release notes here https://docs.microsoft.com/en-us/officeupdates/semi-annual-enterprise-channel
SergeiBaklan You're the man!
Thank you!
AndresCMC , you are welcome
