Share via

I can't unblock Macros on a file and I have tried everything

Colleen Casaday 0 Reputation points
2026-01-15T13:55:35.0466667+00:00

Hello

I have a file that I use that was originally emailed to me. It is for an organization, and I have been using all year. In January, it asked for payment because my subscription was almost up. When I did the payment there became a glitch and it wasn't calculating properly for reports. (Excel) One of my organization members had me sign in to One Cloud and then it totally will not open. Macros are blocking, but I have looked at everything on my computer, and everything looks correct and macros should be blocked. Can you please help me.

Microsoft 365 and Office | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Noel Macadangdang 16,810 Reputation points Independent Advisor
    2026-01-15T14:34:22.52+00:00

    Hi,

    Thank you for sharing your question. You’ve already taken many of the right actions checking macro settings, reviewing Trust Center options, and trying to unblock but the issue persists.

    It’s frustrating and disruptive to your work when a file that’s actively used by your organization gets stuck behind blocked macros right when you need it.

    Microsoft Office blocks macros by default in files from email and OneDrive for security reasons, sometimes even after unblocking the file or enabling macros in settings. To regain functionality, right-click the Excel file in File Explorer, choose Properties, and check "Unblock" on the General tab to remove the Mark-of-the-Web flag. Then in Excel go to File > Options > Trust Center > Trust Center Settings and set Macro Settings to either “Disable all macros with notification” or “Enable all macros,” and also add the folder path as a Trusted Location to prevent future blocks. If the file resides in OneDrive, moving it to a local, trusted folder before reopening can help circumvent the cloud-related block.

     

    I hope this helps.

     

    Best Regards,

    Noel

     

    Was this answer helpful?

    0 comments

  2. AI answer

    2026-01-15T13:55:49.05+00:00

    To unblock macros in your Excel file, you can try the following steps:

    1. Unblock the File: Right-click on the file, select Properties, and look for an Unblock checkbox on the General tab. If it is present, check it and click OK.
    2. Open in Desktop App: If you are accessing the file through OneDrive or SharePoint, try using the Open in Desktop App option. This can sometimes help bypass the macro blocking issue.
    3. Remove Mark of the Web: If you have downloaded the file locally, you can use the PowerShell cmdlet Unblock-File to remove the Mark of the Web from the file. This allows macros to run without being blocked.
    4. Check Trust Center Settings: Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Ensure that the settings allow macros to run. You might want to select "Disable all except digitally signed macros" if you trust the source.
    5. File Block Settings: If the file type is blocked by your organization's policy, you may need to check the File Block Settings in the Trust Center and adjust them accordingly.

    If these steps do not resolve the issue, you may need to consult with your organization's IT department to ensure there are no additional restrictions in place.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.