How to Fix the #NAME? Error After Opening or Uploading an Excel File in WPS Office
Question details
The user needs to resolve #NAME? formula errors that appear after a saved or uploaded Excel workbook is opened, even though the formulas calculate correctly when typed again manually.
- Product
- WPS Office Spreadsheets / Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook is opened or uploaded from an Excel file, and formulas show #NAME? instead of their calculated results.
- Observed behavior
- Formulas display #NAME? after opening or uploading the workbook, but retyping the same formula manually works.
Open the affected workbook in WPS Office Spreadsheets and note which formulas show #NAME?. Check the original Excel version and language, because unsupported functions, undefined names, and regional function-name differences are common causes.
Check and correct function names, defined names, and references
Use this first because #NAME? usually means Excel or WPS does not recognize a function, defined name, or cell reference in the opened file.
The error can be caused by a misspelled function, a named range that does not exist in the current workbook, a reference to a sheet or range that was not saved, or a function not supported by the current version or file format.
Click the cell showing #NAME? and inspect the formula bar to see the full formula and locate the unrecognized part.
In WPS Office Spreadsheets, go to the Formulas tab and click Error Checking or Trace Error to highlight the part of the formula causing the problem.
Retype or edit the function name, sheet name, or range reference so it exactly matches the workbook, then press Enter to recalculate.
Verify named ranges and unsupported functions in the workbook
Use this when the formula looks correct but still shows #NAME? after opening or uploading, especially if the workbook came from another Excel version or language.
Recreate the formulas in a new workbook if the file is damaged
Use this if the error persists after checking names and functions, because the original workbook may be damaged or the formula metadata may not have transferred correctly.
Open and Repair #NAME? Formula Errors in WPS Office Spreadsheets
WPS Office Spreadsheets opens Excel workbooks and provides the formula tools you need to fix #NAME? errors without retyping every formula. You can check Name Manager, trace errors, correct unsupported functions, and save the file as a compatible .xlsx workbook.
- 1. Open WPS Office Spreadsheets: Download and install WPS Office, then open the Spreadsheets application from the WPS Office home screen.
- 2. Open the affected Excel workbook: Click Menu > Open, browse to the workbook that shows #NAME?, and select it to open the file.
- 3. Use formula tools to locate the error: Click the Formulas tab, then use Name Manager and Error Checking to identify the unrecognized name, function, or reference.
- 4. Correct and save the workbook: Edit the incorrect part of the formula, press Enter, then click Menu > Save As and choose Excel Workbook (.xlsx).
Frequently Asked Questions
Why does #NAME? appear after uploading an Excel file?
It means the formula contains a function, defined name, or reference that the current spreadsheet application does not recognize. Open the file in WPS Office Spreadsheets, select the cell, and use Formulas > Error Checking to see which part of the formula is not recognized.
Can I fix #NAME? without retyping every formula?
Yes. In most cases, you only need to correct the unrecognized function or name. Use the formula bar and Name Manager under the Formulas tab to locate the invalid part, then edit only that part and press Enter.
Does WPS Office support the same functions as Microsoft Excel?
WPS Office supports a large set of Excel functions and .xlsx files, but some very new or add-in-specific functions may not be available. If a function is unsupported, replace it with a compatible function or save the workbook as .xlsx.
Is the Excel file corrupted if formulas work when I retype them?
Not necessarily. The workbook may be missing a defined name or reference that did not transfer correctly. If recreating the formulas in a new WPS Office workbook resolves the error, the original file may be damaged.
How do I save an Excel file in WPS Office to avoid #NAME? errors?
In WPS Office Spreadsheets, click Menu > Save As, choose Excel Workbook (.xlsx), and confirm the file name and location. Saving as .xlsx avoids many compatibility and legacy file-format issues.
