Troubleshoot Excel LAMBDA Names and Intermittent #NAME Errors in WPS Office
Question details
The user needs to troubleshoot Excel LAMBDA defined names that fail validation or return intermittent #NAME? errors.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is creating or using LAMBDA functions and encounters validation failures or intermittent #NAME? errors.
- Observed behavior
- The LAMBDA name fails validation or intermittently returns #NAME? even after it previously worked.
Before changing formulas, open Name Manager in WPS Spreadsheets and note the LAMBDA name, scope, and argument list. Confirm that WPS Office is updated so formula-engine fixes are applied.
Recreate the LAMBDA name following Excel defined-name rules
Use this first when a LAMBDA fails validation or intermittently shows #NAME? because a unique name prevents conflicts with reserved names and cell references.
LAMBDA names must start with a letter, underscore, or backslash, and cannot be the same as a cell reference such as A1 or a built-in function name. Recreating the name forces WPS Spreadsheets to revalidate the definition.
Click Formulas > Name Manager in WPS Spreadsheets and locate the LAMBDA name that is failing.
Select the name, click Delete, and confirm to remove the invalid or cached definition.
Click New, enter a unique name such as MYLAMBDA_CALC that does not resemble a cell reference or built-in function, and set the scope.
In the Refers to box, enter the LAMBDA function with valid argument names, for example =LAMBDA(x,x*2), then click OK.
In a worksheet cell, type =MYLAMBDA_CALC(5) and confirm it returns the expected result without #NAME?.
Check workbook scope and localized function syntax
Use this if the LAMBDA name works in one sheet but not another or your installation uses localized function names.
Update WPS Office and test LAMBDA in a new workbook
Use this when names and syntax appear correct but #NAME? errors still occur intermittently.
Fix LAMBDA #NAME? errors in WPS Office Spreadsheets
Use WPS Spreadsheets Name Manager to recreate the LAMBDA name with a valid, workbook-scoped definition, and update the app so formulas validate correctly without intermittent #NAME? errors.
- 1. Open WPS Spreadsheets: Launch WPS Office and open the affected workbook, or create a new spreadsheet.
- 2. Open Name Manager: Click Formulas > Name Manager to review the LAMBDA names currently defined in the workbook.
- 3. Recreate the LAMBDA name: Delete the failing name, click New, and enter a unique LAMBDA name with workbook scope and a valid formula.
- 4. Update and test: Go to Settings/Help > Check for Updates, install updates, then enter =YourLambdaName(argument) in a cell to verify the result.
Frequently Asked Questions
Why does my LAMBDA function return #NAME? after I rename it?
The new name may conflict with a reserved name, cell reference, or existing defined name. Open Formulas > Name Manager, delete the conflicting name, and create a unique LAMBDA name that starts with a letter or underscore.
Can a LAMBDA name be the same as a cell reference like A1?
No. Excel defined-name rules do not allow a LAMBDA name that looks like a cell reference such as A1 or R1C1. Use a descriptive name like CALC_TAX instead.
Why does a LAMBDA work in one worksheet but not another in WPS Spreadsheets?
The LAMBDA name might be scoped to a specific worksheet. In Name Manager, recreate the name with Workbook scope so it is available on every sheet.
How do I edit a LAMBDA defined name in WPS Spreadsheets?
Click Formulas > Name Manager, select the LAMBDA name, and click Edit. Update the Refers to box with the corrected LAMBDA formula and argument names, then click OK and recalculate.
Does WPS Office support Excel LAMBDA functions in .xlsx files?
Yes. WPS Office Spreadsheets supports Excel .xlsx workbooks and LAMBDA defined names, but you may need to update WPS Office and recreate cached names if a file originated in Microsoft 365.
