VBA & Macro Problems

Why Excel Blocks Macros in Email Attachments and How to Fix It

Kushani Nimanthika Oct 14, 2026 870 views

Question details

The user wants to understand why Excel is blocking macros in files downloaded from email attachments and how to safely allow them to run.

Why Excel Blocks Macros in Email Attachments and How to Fix It

Product: Microsoft Excel
Device & OS: not provided
Scenario: Downloading and opening a macro-enabled Excel file (.xlsm) received as an email attachment.
Observed behavior: Excel displays a security warning blocking the macros from running because the file originated from the internet, even if the user has marked the sender as trusted.

Before you start

Ensure that you absolutely trust both the sender and the contents of the macro-enabled file before attempting to unblock it, as malicious macros can severely compromise your computer's security.

Solution 1Recommended

Save and Unblock the File Locally

The most direct way to allow macros to run on a trusted file is to save it to your computer and manually unblock it from the file properties.

Microsoft Office applies a 'Mark of the Web' to files originating from the internet or email attachments. You must manually remove this mark to run macros.

Save the attachment

Download and save the email attachment to a local folder on your computer, such as your Desktop or Documents folder.

Open file properties

Right-click the saved Excel file and select 'Properties' from the context menu.

Unblock the file

Navigate to the 'General' tab. Look for the 'Security' section at the bottom and check the box that says 'Unblock'.

Apply and open

Click 'Apply' and then 'OK' to save the changes. Open the file in Excel, and the macros will now be allowed to run.

Security Check: Once unblocked, the file will no longer trigger the internet-origin security warning on your device.

Solution 2

Move the File to a Trusted Location

Files placed in designated Trusted Locations bypass the internet-origin security checks, allowing macros to run automatically.

Free Microsoft Office alternative

Experience Seamless Compatibility with WPS Office

If you frequently struggle with Microsoft Excel's restrictive macro blocks, complex security settings, or performance issues, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for viewing and editing your essential spreadsheets without the hassle.

1. Download the software: Visit the official WPS Office website to download the free installation package.
2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to complete the setup.
3. Open your spreadsheets: Launch WPS Spreadsheet and open your existing Excel files directly for a seamless editing experience.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .xlsm, .csv).Lightweight installation with a familiar, easy-to-use tabbed interface.Built-in robust security features to safely manage your spreadsheets and data.Free to download and use for your daily document processing needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't trusting the sender's email address unblock the macro?

Microsoft Office applies a 'Mark of the Web' (MotW) to all files originating from the internet or email, regardless of who sent it. The file itself is flagged as a potential risk until you manually unblock it on your local drive.

How can I permanently allow macros from a specific sender?

You cannot whitelist an email sender for macros. However, if the sender uses a digital signature from a Trusted Publisher, you can add their certificate to your Office Trust Center to automatically allow their macros in the future.

Is it safe to unblock macros from email attachments?

It is only safe if you are absolutely certain of the file's origin, the sender's identity, and the exact purpose of the macros. Cybercriminals frequently use malicious macros in disguised email attachments to deliver ransomware and viruses.

Can I disable the internet macro block globally in Excel?

While IT administrators can change these policies using Group Policy settings, it is highly discouraged to disable this feature globally as it leaves your system extremely vulnerable to malware attacks.

Excel & Data Problems