VBA & Macro Problems

How to Share an Excel XLAM Add-in with OneDrive Collaborators

Natalie TaylorNatalie Taylor Nov 3, 2026 870 views

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.

How to Share an Excel XLAM Add-in with OneDrive Collaborators
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.
Before you start

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.

Solution 1Recommended

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.

1
Sync the Shared Folder

Ensure the shared OneDrive folder containing the .xlam file is synced locally to the collaborator's computer via the OneDrive desktop application.

2
Open Excel Add-ins

Open Microsoft Excel, click on 'File', select 'Options' at the bottom, and click on the 'Add-ins' tab in the left sidebar.

3
Manage Add-ins

At the bottom of the Options window, select 'Excel Add-ins' from the Manage drop-down list and click the 'Go' button.

4
Browse and Load

Click 'Browse', navigate to the synced local OneDrive folder where the shared .xlam file is located, select the file, and click 'OK'.

5
Enable the Add-in

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.

Manually Install the XLAM Add-in for Each Collaborator
Trust Center Settings: If Excel blocks the add-in from running, you may need to add the local OneDrive sync folder to Excel's Trusted Locations by going to File > Options > Trust Center > Trust Center Settings > Trusted Locations.
Free Microsoft Office alternative

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.

Highly compatible with Microsoft Excel formats, including .xlsx, .xlsm, and .xlam.Familiar user interface making migration effortless with no steep learning curve.Lightweight software footprint for faster installation and smoother operation.Integrated WPS Cloud makes sharing files and collaborating seamlessly easier.
microsoft office alternative - wps office

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.