Fix Excel #NAME? Errors for Custom Functions in Local XLA Add-ins
Question details
The user needs to resolve a #NAME? error in Excel when using custom VBA functions from a local XLA file that is not loading automatically.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Using custom VBA formulas stored in local XLA add-in files.
- Observed behavior
- Formulas return a #NAME? error unless the XLA file is opened manually, indicating the add-in is not automatically loading or installing at startup.
Ensure you know the exact file path where your local XLA add-in is saved, and verify that the file is not corrupted by successfully opening it manually at least once.
Install and Enable the XLA Add-in via Excel Options
Properly installing the add-in ensures Excel automatically loads your custom functions every time you start the application.
Opening an add-in manually only works for the current session. To make the custom functions permanently available without #NAME? errors, the add-in must be properly installed and checked in the Add-ins manager.
Launch Excel and navigate to File > Options. From the left-hand sidebar, click on Add-ins.
At the bottom of the window, locate the Manage drop-down menu, ensure 'Excel Add-ins' is selected, and click the 'Go...' button.
Click the 'Browse' button to locate your local .xla file. Once selected, ensure the checkbox next to your add-in's name is checked in the list, then click OK.
Place the Add-in in the XLSTART Folder
Any valid Excel file or add-in placed in the XLSTART directory will automatically load when Excel is launched.
Move Reusable Functions to Personal.xlsb
Migrating your custom VBA code to the Personal Macro Workbook ensures it is natively loaded and always available across all your Excel files.
Run Custom Macros and Add-ins with WPS Spreadsheet
WPS Spreadsheet offers robust VBA and macro support out of the box. You can easily manage and load your custom .xla add-ins to maintain productivity without frustrating formula errors.
- 1. Access Developer Tools: Open WPS Spreadsheet, click on the Developer tab in the top ribbon menu, and select Add-Ins.
- 2. Manage Add-ins: In the Add-Ins dialog box, click on 'Manage' and select 'Browse' to locate your local .xla file.
- 3. Enable the Add-in: Check the box next to your imported add-in name and click OK. Your custom functions are now ready to use without #NAME? errors.
Frequently Asked Questions
Why does Excel show a #NAME? error for my custom function?
This error occurs when Excel does not recognize the function name you typed. For custom VBA functions, it usually means the add-in containing the function was not loaded properly when Excel started.
What is the difference between opening an XLA file and loading it?
Opening an XLA file temporarily makes its macros available only for that specific session. Loading it via Excel Add-ins installs it in the background, ensuring Excel automatically activates it every time you launch the software.
How do I find my XLSTART folder?
The XLSTART folder is typically located in your AppData directory. You can quickly navigate to it by pressing Win + R, typing %appdata%\Microsoft\Excel\XLSTART, and pressing Enter.
Can I create the XLSTART folder manually if it's missing?
Yes, if the XLSTART folder does not exist in your Microsoft\Excel directory, you can manually create a new folder, name it exactly XLSTART, and Excel will recognize it and load its contents upon startup.
