Share via

Excel Mac LET function not working on current build

Anonymous
2022-10-28T00:01:36+00:00

I shared a workbook containing a LET function with a colleague and he's found that Excel isn't recognizing it. It appears we're using the same build (Mac 16.66.1 22101101).

The function in the workbook he opened is preceded by _xlfn.LET, suggesting that Excel doesn't know what this is.

I'm on the Insider channel, but LET should have been rolled out months ago. He's tried reinstalling Excel, same result. What might be going on here?

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-10-28T16:25:03+00:00

    Hi Brett,

    In addition to having the same build number, the license type must be one that doesn't block feature updates. I suspect there are differences between the two licenses (yours and the one that is not working right).

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-10-28T02:15:42+00:00

    Dear Brett,

    Welcome to the forum here.

    Could you share some sample data with the LET function you are using in the Excel file for our confirmation so that we can do a test in our environment with the Excel for Mac application Mac 16.66.1 in our environment to see the result as well?

    Note: Remove any private information before uploading the screenshots.

    Thanks for your effort and time!

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments