Fix Excel for Mac LET Function Showing _xlfn.LET Error
Question details
Users need to resolve an issue where the LET function in Excel for Mac does not compute and displays an '_xlfn.LET' prefix, even when build numbers match between devices.
- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Opening or editing a spreadsheet that relies on the dynamic LET function.
- Observed behavior
- The LET formula is prefixed with '_xlfn.', indicating it is unrecognized or unsupported, causing the formula to fail and preventing the spreadsheet from working properly.
Verify your exact Microsoft Office license type (such as a Microsoft 365 subscription versus a one-time purchase like Office 2019) and check which update channel your Mac is currently enrolled in.
Verify Microsoft 365 License and Update Channel
The LET function is available primarily to Microsoft 365 subscribers. Confirming your license type and update channel ensures your installation is eligible for the latest dynamic array features.
Matching build numbers on different Mac devices do not guarantee the same feature sets. Standalone licenses (like Office 2019 or 2021) or restricted enterprise update channels often block newer functions like LET, which causes Excel to display the _xlfn prefix error.
Launch Excel on your Mac, click on 'Excel' in the top Apple menu bar, and select 'About Microsoft Excel'.
In the dialog box that appears, look at the 'License' field. It must clearly state 'Microsoft 365 Subscription' to support the LET function. If it lists a year (e.g., 2019), your license does not include this feature.
Navigate to 'Help' > 'Check for Updates' in the top menu. Ensure you are on the Current Channel or Beta Channel, as Deferred or Enterprise channels may delay the rollout of the LET function.
Test with a Sample LET Formula
Create a simplified sample workbook to verify whether the error is caused by corruption in your specific file or if the Excel installation itself lacks support.
Use WPS Office for Hassle-Free Spreadsheet Management
Tired of missing features due to confusing license types and update channels? WPS Office provides a free, lightweight, and incredibly powerful spreadsheet tool with a familiar UI, offering seamless migration and excellent format compatibility without the licensing headaches.
- 1. Download WPS Office: Visit the official WPS Office website and download the free version for Mac.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx files instantly.
- 3. Work Without Restrictions: Edit and manage your data with an intuitive interface and high format compatibility.
Frequently Asked Questions
What does the _xlfn. prefix mean in Excel?
The _xlfn. prefix appears when a workbook contains a function that is not supported by the version of Excel currently opening it. It indicates that the function exists in newer versions but is unavailable in your current build or license type.
Why do two Macs with the exact same Excel build number have different features?
Features in Microsoft Excel are controlled by both the license type and the update channel, not just the build number. A Microsoft 365 subscription receives continuous feature updates, whereas standalone licenses (like Office 2019 or 2021) only receive security updates and will not unlock newer functions like LET.
Can I manually remove the _xlfn. prefix to make my formula work?
No, manually deleting the _xlfn. prefix will result in a '#NAME?' error. The underlying Excel application still does not recognize the function. To fix it, you must upgrade to a supporting license, change your update channel, or rewrite the formula using older, widely supported functions.
