Excel LET Function Returns Name Error After Sharing Workbook: Fix

You shared an Excel workbook with colleagues, and formulas that use the LET function now show a #NAME? error. This happens because the LET function is a newer function that requires Excel 2021 or Microsoft 365, and some recipients may have an older version that does not recognize it. This article explains why the error occurs after sharing, provides a step-by-step fix to resolve it, and covers related issues such as compatibility mode and linked workbooks.

Why the LET Function Causes a #NAME? Error in Shared Workbooks

The LET function was introduced in Excel 2021 and is also available in Excel for Microsoft 365. It assigns names to calculation results, which reduces formula repetition and improves performance. When you share a workbook, recipients who open it in Excel 2019, Excel 2016, or earlier versions will see a #NAME? error because those versions do not contain the LET function in their formula engine.

The error is not caused by a broken reference or a typo. It is a version incompatibility issue. Excel treats the LET function as an undefined name in older versions, so it cannot evaluate the formula. The same problem occurs with other newer functions such as XLOOKUP, FILTER, and LAMBDA.

If you share the workbook via email, a network drive, or a cloud service like OneDrive, the error appears on the recipient’s screen. The workbook may also show a yellow bar at the top that says “Compatibility Mode.” This bar indicates that some features in the workbook are not supported in the current version of Excel.

Steps to Fix the LET Function #NAME? Error After Sharing

There are three reliable methods to fix this error. Choose the method that best fits your situation.

Method 1: Check Compatibility Before Sharing

Use Excel’s built-in compatibility checker to see exactly which formulas will fail. This does not fix the error on the recipient’s side, but it tells you which cells to modify.

1. Open the workbook in Excel for Microsoft 365 or Excel 2021
   Make sure you are using a version that supports the LET function.
2. Go to File > Info
   Click the File tab, then select Info from the left menu.
3. Click Check for Issues, then Check Compatibility
   A dialog box opens listing features that are not supported in earlier versions. Look for rows that say “LET function” or “Name error.”
4. Note the cell references
   Write down the cell addresses listed in the compatibility report. These are the cells that will show #NAME? when shared.

Method 2: Replace LET with a Compatible Formula

Rewrite each LET formula using nested IF, helper columns, or a combination of standard functions. This method ensures the workbook works in Excel 2019 and earlier.

1. Identify the LET formula structure
   A LET formula looks like this: =LET(x, A1+10, x2). The first argument after LET is the name, the second is the value, and the third is the calculation that uses the name.
2. Replace the name with the value in the calculation
   Instead of =LET(x, A1+10, x2), write =(A1+10)2. This works in all Excel versions.
3. Use a helper column for complex LET formulas
   If the LET formula calculates a long intermediate result, put that result in a separate cell. For example, put =A1+10 in cell B1, then in cell C1 write =B12.
4. Test the workbook in an older version
   Open the workbook in Excel 2019 or use the Compatibility Mode in Excel 365 by saving a copy as an .xls file and reopening it.

Method 3: Use LAMBDA as an Alternative (Microsoft 365 Only)

If all recipients use Excel for Microsoft 365, you can replace LET with LAMBDA. Both functions require the same version, but LAMBDA can sometimes avoid the #NAME? error when the workbook is opened in a newer build. This is a niche fix and not a general solution for older versions.

1. Open the Name Manager
   Go to Formulas > Name Manager.
2. Create a new named range using LAMBDA
   Click New, enter a name like CalcResult, and in the Refers to box type =LAMBDA(x, x2). Click OK.
3. Use the named range in the cell
   In the cell, write =CalcResult(A1+10). This works only in Excel for Microsoft 365.

If the LET Function Still Shows #NAME? After the Fix

Excel Opens the Workbook in Compatibility Mode Automatically

When you open a workbook saved in an older format (.xls), Excel switches to Compatibility Mode. In this mode, even if you have Excel 365, the LET function may not work. Save the workbook in the .xlsx format before sharing. Go to File > Save As and choose Excel Workbook (xlsx).

Linked Workbooks Show #NAME? from LET

If the shared workbook contains external links to another workbook that uses LET, the #NAME? error can appear in the linked cells. To fix this, open the source workbook and replace the LET formulas there using Method 2. Then update the links in the shared workbook by going to Data > Edit Links > Update Values.

Excel for Mac Shows #NAME? with LET

Excel for Mac version 16.54 and earlier does not support the LET function. If you share the workbook with a Mac user, they will see the error. Ask them to update Excel for Mac to version 16.55 or later. Alternatively, replace the LET formulas before sharing.

Replace LET vs Convert to Helper Columns: Key Differences

Item	Replace LET with Nested Functions	Convert LET to Helper Columns
Description	Rewrite the LET formula so it uses only standard Excel functions without intermediate names	Move the intermediate calculation to a separate cell and reference that cell in the final formula
Compatibility	Works in Excel 2010 and later	Works in Excel 2007 and later
Workbook size	Stays the same — no extra cells added	Increases because of additional columns or rows
Maintenance	Harder to read — long nested formulas	Easier to audit — each step is visible in its own cell

Now you can identify which cells use the LET function, check compatibility before sharing, and rewrite formulas to avoid the #NAME? error. Start by running the compatibility checker on your original workbook. For a long-term solution, consider using helper columns instead of LET when you know the workbook will be opened by users with older Excel versions. This approach keeps your data accurate and accessible to everyone.