How to Enable Excel Macros for *.xlsm Files on OneDrive

This post is being made in the hopes that it will save some other people time that are still looking for a fix, or will be looking for a fix in the future.

1. Open Excel

2. Navigate to Trust Center Settings

   1. Developer > Macro Security OR

   2. File > Options > Trust Center > Trust Center Settings

3. Go to Trusted Locations

4. Click "add new location" and put https://d.docs.live.net in the text box that pops up.

   1. Be sure to click the checkbox "Subfolders of this location are also trusted"

5. Click Ok and restart excel.

Note, this will trust all macros of all files in your OneDrive, so I recommend taking the appropriate security steps to ensure you're only saving files in OneDrive (that you want to open in app, at least) that you trust.

Source: 

Solution: Enabling Macros on Workbooks from OneDrive

Reddit · r/excel

60+ comments · 2 years ago