How to Share an Excel XLAM Add-in with OneDrive Collaborators
Question details
Users need to share a custom Excel .xlam add-in with collaborators via OneDrive to ensure custom functions work properly across different machines.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Collaborating on a shared Excel workbook that utilizes custom VBA functions stored in an external XLAM add-in via OneDrive.
- Observed behavior
- The add-in functions correctly for the file owner, but collaborators see #NAME? errors because the add-in is not automatically loaded on their local machines.
Verify that all collaborators have permission to run macros in their Trust Center settings and ensure the .xlam file is saved in a OneDrive folder that is fully synced to everyone's local computer.
Manually Install the XLAM Add-in for Each Collaborator
The most effective way to fix broken custom functions is for each collaborator to manually load the add-in from their local synced OneDrive folder.
Because Excel relies on local file paths to run external code, the custom add-in must be connected manually on each computer interacting with the spreadsheet. Simply sharing the file on OneDrive does not automatically register the macro code on another user's Excel instance.
Ensure the shared OneDrive folder containing the .xlam file is synced locally to the collaborator's computer via the OneDrive desktop application.
Open Microsoft Excel, click on 'File', select 'Options' at the bottom, and click on the 'Add-ins' tab in the left sidebar.
At the bottom of the Options window, select 'Excel Add-ins' from the Manage drop-down list and click the 'Go' button.
Click 'Browse', navigate to the synced local OneDrive folder where the shared .xlam file is located, select the file, and click 'OK'.
Verify that the check box next to the add-in's name is selected in the Add-ins dialog box, then click 'OK' to activate it for that user's environment.

Try WPS Office for Seamless Collaboration
If managing add-in paths and macro settings across different Excel users is causing productivity bottlenecks, consider using WPS Office. It provides powerful spreadsheet features, excellent macro compatibility, and built-in cloud collaboration—completely free.

Frequently Asked Questions
Why do my custom functions display a #NAME? error on other computers?
The #NAME? error appears when Excel cannot find the external code that calculates the custom function. Because the .xlam file path on your computer differs from your collaborators' computers, their Excel instances cannot automatically locate and load the add-in.
Can I embed the XLAM add-in directly into the workbook to avoid sharing it separately?
An .xlam file is specifically designed to operate as a standalone add-in file. If you want the functions to be built into the workbook itself so sharing is easier, you must save the document as a Macro-Enabled Workbook (.xlsm) and copy the VBA code directly into the workbook's internal modules.
Does Excel support loading add-ins directly from an online OneDrive URL?
No, Excel requires a local or explicitly mapped network drive path to properly load an add-in. Users cannot directly browse to an 'https://' OneDrive link in the Add-ins manager, which is why the folder must be synced locally using the OneDrive client.




