Function Problems

Fix Foreign-Language User-Defined Functions and #NAME? Errors in Excel

Bushra ParveenBushra Parveen Nov 14, 2026 868 views

Question details

Identify why Excel user-defined functions appear in different languages and why some formulas return #NAME? errors or show an add-in path.

Fix Foreign-Language User-Defined Functions and #NAME? Errors in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook uses user-defined functions after university and other add-ins were enabled.
Observed behavior
Function names appear in French, German, Finnish, and other languages. Some formulas return #NAME? and display an add-in folder path; the language issue continues after the two recently added university add-ins are deactivated.
Before you start

Identify an affected formula and note its function name and any add-in file path shown in the formula bar. Have the names and installation locations of the required add-ins available; menu names can vary by Excel version and operating system.

Solution 1Recommended

Check the required add-ins and formula references

Use this to determine whether Excel can find the add-in that supplies an affected function.

1
Inspect an affected formula

Select a cell showing #NAME? and check the formula bar for the function name and any add-in file or folder path. Note whether the path points to a location that exists on this computer.

2
Review installed add-ins

In Excel for Windows, open File > Options > Add-ins. Review the active and inactive add-ins, then use the Manage list and Go button for the relevant add-in type to check whether the required add-in is enabled.

3
Check the add-in location

Compare the path in the formula bar with the installed add-in location. If the file is missing or the path is outdated, ask the university add-in provider for the correct installation and reference instructions.

4
Recheck the formula

After restoring the required add-in or reference, select the affected cell, press F2, and press Enter to recalculate the formula.

Check the required add-ins and formula references
Disabling an add-in may not remove references: A formula can retain an add-in path or function name after the add-in is disabled. The continuing language issue does not by itself establish that the two recently added add-ins are the only cause.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. It can help with everyday workbook tasks and migration, but it does not repair Excel add-ins, and custom functions or VBA may not work the same way.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet formulas in a familiar interfaceUse a free, lightweight office suite for everyday workMove common documents and spreadsheets between office suites
microsoft office alternative - wps office

Frequently Asked Questions

Why does an Excel user-defined function return #NAME?

Excel may not recognize the function because its add-in is missing, disabled, or referenced at an unavailable path. Check the formula bar and, in Excel for Windows, review File > Options > Add-ins.

Does deactivating an add-in remove its function names from formulas?

Not necessarily. Existing formulas can retain function names or add-in paths after deactivation. Select an affected cell and inspect the formula bar to see what is still referenced.

Should I translate every foreign-language function name into English?

No. First determine whether the function is built into Excel or supplied by an add-in. Custom functions must use the exact name supported by their provider, which may not be a direct translation.

What if the formula points to an old add-in folder?

Compare the path shown in the formula bar with the add-in's current installation location. Ask the add-in provider for the correct installation and reference instructions before changing the formula.

Can WPS Office fix my university's Excel add-in?

No. WPS Office is an alternative for working with common spreadsheet files, but it does not repair Microsoft Excel add-ins. Check custom function and macro compatibility before relying on the workbook in WPS.