Share via

Not able to use the file as is

Mirza Sara Ali 0 Reputation points
2026-05-27T06:08:45.71+00:00

I'm not able to use this particular file since a few days and it's creating barrier in my work. Can you please fix this I tried Unblocking all the macros from the macros settings as well.

Microsoft 365 and Office | OneDrive | For business | Other
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Darren-Ng 10,455 Reputation points Microsoft External Staff Moderator
    2026-05-27T06:38:08.6966667+00:00

    Dear @Mirza Sara Ali,

    Thank you for posting your question in the Microsoft Q&A forum.

    Based on your description, you are unable to use a specific file for the past few days even after unblocking macros, which is impacting your work.

    To help narrow down the cause, could you please confirm:

    Do you see any error message?

    Where is the file stored (local drive, OneDrive, email attachment, or network share)?

    Is there an Unblock option in the file properties?

    If you are using a work account, your organization’s security policy may also be blocking macros. Have you tried to contact your IT administrator to check policy?

    Please understand that the more information you provide, the more effectively I can support.

    Looking forward to your update.

    Was this answer helpful?

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. AI answer

    2026-05-27T06:09:00.5933333+00:00

    Follow these steps to get the file working again, focusing on macro blocking and “Mark of the Web” (files from the internet/OneDrive/SharePoint):

    1. Save the file locally
      • If the file is on OneDrive/SharePoint or a network share, download it to the local drive first (for example, Downloads or Documents).
    2. Remove the “blocked from internet” flag (Mark of the Web)
      • Close Excel/Word/Office app.
      • In File Explorer, right‑click the problem file > Properties.
      • On the General tab:
        • If there is a Security section with an Unblock checkbox, select Unblock.
        • Click Apply and OK.
      • Reopen the file and test the macros.
    3. If the file is still blocked and is stored online
      • If the file is on OneDrive or SharePoint, try opening it directly with Open in Desktop App from the web interface instead of downloading first.
      • If you must work from a network/SharePoint/OneDrive location regularly, ask the admin to:
        • Add that location as a Trusted site or to Local intranet zone via Control Panel > Internet Options > Security.
        • This prevents macros from being blocked for all files in that trusted location (ensure only controlled, safe locations are added).
    4. If macros are still blocked after Unblock
      • There may be a policy or Trust Center setting that still prevents macros from running.
      • An admin can review macro policies such as Block macros from running in Office files from the Internet and VBA Macro Notification Settings. If those are configured to block macros, they override user macro settings.
    5. Optional: Unblock via PowerShell (for many files)
      • If there are multiple affected files, an admin can run the Unblock-File PowerShell cmdlet on them to remove Mark of the Web, which has the same effect as checking Unblock in Properties.

    If the file is an older Excel 4.0 macro workbook (XLM) and not VBA, ensure in Excel:

    • File > Options > Trust Center > Trust Center Settings > Macro Settings:
      • Enable Excel 4.0 macros when VBA macros are enabled is checked.
    • File > Options > Trust Center > Trust Center Settings > File Block Settings:
      • Under File Type, select Excel 4 MacroSheets and ensure Open is checked.
      • Under Open behavior for selected file types, choose Open selected file types in Protected View and allow editing.

    If, after unblocking the file and confirming these settings, the file still cannot be used, an organization‑level macro policy is likely enforcing stricter blocking and needs to be adjusted by the administrator.

    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.