Untrusted Document - Macros not working
Step 1
If you're seeing a banner at the top of an Excel document that reads (or something like this):
and you're missing the ability to Enable Content, it's likely that you need to make it a trusted document.
Step 2
In Excel, navigate to File > Options > Trust Center > Trust Center Settings > Trusted Locations
Step 3
Click Add new location.
Step 4
Create a folder in your OneDrive (e.g., Trusted Excel Documents).
Step 5
Save the Excel file to this folder. Make sure you're closed out of Excel.
Step 6
Reopen the file and it should now work.