Formula Errors

Fix #NAME? Errors in Excel 2016 After Opening Excel 2010 Files

Ayan MasoodAyan Masood Nov 20, 2026 868 views

Question details

Identify why formulas in Excel 2010 workbooks show #NAME? errors after the files are opened and edited in Excel 2016.

Fix #NAME? Errors in Excel 2016 After Opening Excel 2010 Files
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.
Before you start

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.

Solution 1Recommended

Check Formula Names and Required Add-ins in Excel 2016

Use this approach to find unrecognized functions, missing defined names, or unavailable add-ins.

1
Inspect an affected formula

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.

2
Check defined names

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.

3
Review add-ins

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.

4
Check custom functions

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.

Check Formula Names and Required Add-ins in Excel 2016
Why #NAME? appears: Excel displays #NAME? when it cannot recognize text in a formula, such as a function name or defined name. A missing add-in or unavailable custom function can also cause the error.
Free Microsoft Office alternative

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.

Review spreadsheet formulas in a familiar interfaceOpen and save Microsoft Excel formats, including XLSX and XLSUse a free, lightweight office suiteMove compatible workbooks between WPS Office and Microsoft Office
microsoft office alternative - wps office

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.