A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Dear Peter_1985,
Good day! Thank you for sharing your concern with us here in the Microsoft Q&A forum.
We apologize for any inconvenience you may encounter when using our services/ products. Based on your description, kindly try these following steps:
1. "Microsoft has blocked macros from running because the source of this file is untrusted"
- Right-click the file in File Explorer.
- Select Properties.
- In the General tab, check the box that says "Unblock" (if available).
- Click Apply and then OK.
- Reopen the file.
2. "The ActiveX content in this file is blocked"
- Open the file > Click Enable Content in the yellow Message Bar.
- Go to File > Options > Trust Center > Trust Center Settings > ActiveX Settings
- Choose appropriate settings (e.g., “Prompt me before enabling all controls”).
- Add the file’s folder to Trusted Locations.
Here are some references:
Enable or disable ActiveX settings in Office files - Microsoft Support
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.