How to Fix Previously Working Macros in Excel that are Now Blocked/Not Loading

Question

(Note: I was directed here from MS Support)

I have several excel files that I use in daily work that have macros in them, executed via buttons. While working with one of these files, the macros stopped working. These files are important enough that I maintain backups.

I loaded the backup when the file I was using ceased to function, and experienced the same problem. I went to the author of the spreadsheet (a co-worker) and told him of the issue. I then emailed him the file.

The file worked fine on his PC. I asked him to rename it and send it back. When I opened it originally, it would show the usual "Enable Content" ribbon, but when I would then go to the policy "Security Risk/Learn more" ribbon.

What I have done to resolve this issue to no avail:

I have stored the emailed file to OneDrive and unblocked the web-block via properties.

I have made OneDrive online a trusted location.

I have used Trust Center to make a hard drive location a trusted location, and saved the attached file to that location.

I have created a new folder, made it a trusted location, saved the file in that folder.

I have used PowerShell to unblock the file in the above locations.

I have turned off all features in Trust Center that could cause the file to be blocked, and it is still blocked.

Here is the relevant XLTCD.LOG:

"File Name: {File Name}.xlsm"

Date/Time Opened: 2/27/2025 5:03 PM

Content Type: VBA Macro

Certificate: Unknown (no security check)

Certificate Signature: Unknown (no security check)

Certificate Status: Unknown (no security check)

Trust Center Decision: Not Load"

Any help with this situation would be greatly appreciated.

Answer 1

Hi @SRENV

1. Are you using Microsoft 365 Apps? Does the file author use the same version of Office as yours?
2. Besides, are you and the co-workers in the same organization?
3. Could you please share us with a screenshot of the prompt in Excel?

When I opened it originally, it would show the usual "Enable Content" ribbon, but when I would then go to the policy "Security Risk/Learn more" ribbon.

Please make sure, the policy "Block macros from running in Office files from the Internet" is not enabled in the Group Policy Management Console under User Configuration\Policies\Administrative Templates\Microsoft Excel 2016\Excel Options\Security\Trust Center.

Ensure your organization IT did not enable "Block macros from running in Office files from the internet" for Excel in Microsoft 365 Admin Center > Customization > Policy Management.

I have created a new folder, made it a trusted location, saved the file in that folder.

You downloaded the file to a local folder instead of local OneDrive folder, and this folder was added as an Office trusted location, but this issue still occurs, am I right?I have to confirm that you have enabled the macros, disabled Protected View in Trust Center.

If you have done this, I suggest you perform an Online Repair for your Office.

---

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.

---