Share Macro enabled workbook(s)

Core Solution: Add https://d.docs.live.net as a Trusted Location

According to multiple Microsoft Q&A and Stack Overflow discussions, this is the most direct and proven effective method:

1. On the shared computer, open the Excel desktop application (not Excel Online).
2. Go to File → Options → Trust Center → Trust Center Settings.
3. Select Trusted Locations from the left menu.
4. Click Add new location.
5. Enter in the path field: https://d.docs.live.net (leave out the quotes).
6. Check Subfolders of this location are also trusted.
7. Click OK and restart Excel.

Your Previous Attempts Failed…

Many "how-to" guides teach users to add a local sync folder path (like C:\Users\...\OneDrive) to Trusted Locations, but this doesn't work for OneDrive shared files. The reason is that when Excel processes shared files through OneDrive, it identifies the source as a network location (related to d.docs.live.net), not a local path. So the key is to tell Excel to trust the root domain of OneDrive, not the local folder.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.