SOLVED

Excel 365 LET Function not recognized

Copper 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 (Copper 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

 

 

1 best response

Accepted Solutions
best response confirmed by AndresCMC (Copper Contributor)
Solution

@AndresCMC 

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

View solution in original post