Fix #NAME? Errors in Excel 2016 After Opening Excel 2010 Files
Question details
Identify why formulas in Excel 2010 workbooks show #NAME? errors after the files are opened and edited in Excel 2016.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Workbooks created or previously working in Excel 2010 are opened and edited in Excel 2016 on multiple computers.
- Observed behavior
- Affected formulas display #NAME? errors in Excel 2016, including in locally copied files.
Open an affected workbook in Excel 2010, if available, and note a formula that works there but shows #NAME? in Excel 2016. Check whether the formula uses a defined name, a custom function, or an add-in.
Check Formula Names and Required Add-ins in Excel 2016
Use this approach to find unrecognized functions, missing defined names, or unavailable add-ins.
Select a cell showing #NAME? and examine its formula in the formula bar. Compare function names, spelling, and quotation marks with the working formula in Excel 2010.
Go to Formulas > Name Manager and look for names referenced by the affected formula. Check their spelling, scope, and referenced ranges against the working workbook.
Go to File > Options > Add-ins. Use the Manage list and Go button to inspect Excel Add-ins and COM Add-ins, then compare them with the Excel 2010 setup. Install or enable a required trusted add-in if it is available for Excel 2016.
If the formula calls a macro or custom function, open Developer > Visual Basic and check whether its code is present and available. Review any security warnings before enabling content, and enable macros only if you trust the file and its source.

Run Compatibility Checker and Test the Affected Workbook
Use compatibility checks and a small test file to narrow down workbook-specific issues.
Open and Review Excel Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing compatible Excel workbooks. Its format support helps you move between office suites, although it does not fix Excel 2016 settings or guarantee compatibility with every add-in or custom function.

Frequently Asked Questions
Why does Excel show #NAME? for a formula that worked in Excel 2010?
Excel 2016 may not recognize a defined name, function, or custom function used by the formula. Select the affected cell and compare its formula and required add-ins with the Excel 2010 setup.
Where can I check whether a defined name is missing?
Open Formulas > Name Manager in Excel 2016. Find the name used in the formula and check its spelling, scope, and referenced range.
Will saving the workbook as XLS fix the error?
Not necessarily. Saving a separate XLS copy can reveal compatibility warnings, but it will not install a missing add-in or restore an unavailable custom function. The older format can also change or remove unsupported features.
How do I find my Excel 2016 build number?
In Excel, select File > Account > About Excel. Note the version and build information shown there when comparing affected computers or requesting support.




