Fix Foreign-Language User-Defined Functions and #NAME? Errors in Excel
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.

- 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.
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.
Check the required add-ins and formula references
Use this to determine whether Excel can find the add-in that supplies an affected function.
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.
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.
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.
After restoring the required add-in or reference, select the affected cell, press F2, and press Enter to recalculate the formula.

Isolate the workbook and add-in environment
Compare the workbook in another Excel environment to identify whether the behavior depends on installed add-ins or saved formulas.
Verify function names and Excel language settings
Use this when a formula may contain a localized built-in function name or a custom function name supplied by an add-in.
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.

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.




