SOLVED

Excel 365 LET Function not recognized

%3CLINGO-SUB%20id%3D%22lingo-sub-1862830%22%20slang%3D%22en-US%22%3EExcel%20365%20LET%20Function%20not%20recognized%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862830%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20just%20upgraded%20to%20Office%20365%20ProPlus%3C%2FP%3E%3CP%3EThe%20LET%20function%20is%20not%20available.%3C%2FP%3E%3CP%3EDoes%20anybody%20know%20how%20to%20fix%20this%20issue%3F%3C%2FP%3E%3CP%3E%5CThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1862830%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862902%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20LET%20Function%20not%20recognized%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F860615%22%20target%3D%22_blank%22%3E%40AndresCMC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20you%20are%20on%20semi-annual%20channel%2C%20if%20so%20update%20on%20Current%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1869397%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20LET%20Function%20not%20recognized%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1869397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F860615%22%20target%3D%22_blank%22%3E%40AndresCMC%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I just upgraded to Office 365 ProPlus

The LET function is not available.

Does anybody know how to fix this issue?

\Thank you

 

5 Replies
best response confirmed by AndresCMC (New Contributor)
Solution

@AndresCMC 

Most probably you are on semi-annual channel, if so update on Current one.

@Sergei Baklan  You're the man!

Thank you!

@AndresCMC , you are welcome

@Sergei Baklan 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.  
Gav

@GavCol_icr 

How 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