VBA & Macro Problems

How to Fix Microsoft Has Blocked Macros in an Excel File

Steve K Sep 28, 2026 869 views

Question details

The user needs to enable and run macros in an Excel file that was downloaded from the internet, which Microsoft has automatically blocked for security reasons.

How to Fix Microsoft Has Blocked Macros in an Excel File

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a macro-enabled Excel file that has been downloaded from an internet source, email attachment, or network location.
Observed behavior: Excel displays a security warning stating that Microsoft has blocked macros from running. Adding the source website to Trusted Sites does not resolve the issue.

Before you start

Ensure that you absolutely trust the source of the Excel file. Macros can contain malicious code, so only proceed if you know the file is safe, verified, and comes from a reputable sender.

Solution 1Recommended

Unblock Macros via File Properties

The quickest and most secure way to allow macros to run for a specific downloaded file is to remove its internet security mark directly from the file properties.

When you download a file from the internet, Windows attaches a 'Mark of the Web' (MOTW) to it. Microsoft Office checks for this mark and automatically blocks macros to protect your computer. Unblocking the file removes this mark.

Close the Excel File

Ensure the blocked Excel file is completely closed before attempting to change its properties.

Open File Properties

Locate the downloaded Excel file in Windows File Explorer, right-click on it, and select 'Properties' from the context menu.

Check the Unblock Box

In the 'General' tab, look at the bottom for a Security section. Check the box next to 'Unblock' (or click the 'Unblock' button, depending on your Windows version).

Apply Changes

Click 'Apply' and then 'OK' to save the changes. You can now reopen the file in Excel, and the macros should run without being blocked.

Verified Sources Only: This method is highly recommended over changing global macro security settings, as it only trusts this specific verified file.

Solution 2

Move the File to a Trusted Location

If you frequently download macro-enabled files from a secure internal source, you can set up a Trusted Location in Excel to automatically bypass the block.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Management with WPS Office

Tired of complicated security settings and blocked macros? WPS Office provides a lightweight, highly compatible alternative to Microsoft Excel, offering robust features and a familiar interface without the hassle.

1. Download and Install: Visit the official WPS website to download the free WPS Office installer and follow the on-screen prompts.
2. Open WPS Spreadsheets: Launch WPS Office and click on 'Spreadsheets' to start a new document or open an existing one.
3. Load Your Excel File: Simply drag and drop your .xlsx or .xlsm file into the workspace for immediate, highly compatible viewing and editing.

Completely free and lightweight office suiteExcellent compatibility with Microsoft Excel formats (.xlsx, .xlsm, .xls)Intuitive, familiar user interface that requires no learning curveRobust data analysis and calculation tools for everyday tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel suddenly block all my downloaded macros?

Microsoft introduced a security update that automatically blocks VBA macros in files originating from the internet (indicated by a 'Mark of the Web') by default. This is to protect users from malicious code commonly distributed via downloaded spreadsheets.

How do I know if an Excel file with macros is safe to unblock?

Only unblock macros if you know and trust the sender, were expecting the file, and have verified its contents. If the file was downloaded from an unknown website or sent by an unrecognized email address, do not unblock it.

Can I completely turn off this macro blocking feature?

While you can change macro settings in the Trust Center, it is highly discouraged to lower your macro security globally. Doing so removes the block for all files, leaving your computer vulnerable to automated malware attacks.

Does unblocking one file affect other files in the same folder?

No. When you unblock an individual file via its 'Properties' menu, the change only applies to that specific file. To trust multiple files automatically, you must place them in a designated Trusted Location.

Excel & Data Problems