VBA & Macro Problems

How to Fix Excel Blocking Macros Because the File Source Is Untrusted

Guest Writer Sep 28, 2026 869 views

Question details

The user needs to bypass or resolve a Microsoft Excel security warning that blocks macros from running because the file originates from an untrusted source, even though VBA macros are enabled in the settings.

How to Fix Excel Blocking Macros Because the File Source Is Untrusted

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a macro-enabled Excel file that was downloaded from the internet or received as an email attachment.
Observed behavior: Excel displays a 'Security risk' alert stating that Microsoft has blocked macros from running because the source of the file is untrusted, preventing any VBA code from executing.

Before you start

Before attempting to bypass this security block, verify that the Excel file comes from a completely trusted source, as malicious macros can execute harmful code on your computer.

Solution 1Recommended

Unblock the File via Windows Properties

This is the most secure and recommended method for unblocking a specific macro-enabled file that you have downloaded and verified as safe.

Microsoft uses a 'Mark of the Web' (MOTW) tag for files downloaded from the internet. By default, Excel now blocks macros in these files to protect your system. You can manually remove this tag in the file's properties.

Close the Excel File

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

Locate the File in File Explorer

Open Windows File Explorer and navigate to the folder where the downloaded Excel file is saved.

Open File Properties

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

Check the Unblock Box

On the 'General' tab, look at the bottom for a 'Security' section. Check the box labeled 'Unblock', then click 'Apply' and 'OK'.

Macros Enabled: The next time you open the file in Excel, the untrusted source block will be removed and your macros will run normally.

Solution 2

Save Files to a Trusted Location

Use this method if you frequently receive macro-enabled files from colleagues or external systems and want a dedicated folder where macros are always allowed.

Free Microsoft Office alternative

Try WPS Office for a Hassle-Free Spreadsheet Experience

If you are frustrated by frequent Microsoft Office security blocks, complex settings, and unexpected updates, consider switching to WPS Office. It provides an intuitive, lightweight platform with outstanding compatibility for Excel files, helping you manage your spreadsheets smoothly.

1. Download the Installer: Visit the official WPS Office website and download the free installation file.
2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your computer.
3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel files to experience seamless and safe editing.

Seamless compatibility with Microsoft Excel formats (.xls, .xlsx, .xlsm, .csv)Lightweight design ensures fast launch times and smooth performanceFamiliar user interface that requires zero learning curveFree to use for all essential office tasks and document management

microsoft office alternative - wps office

Frequently Asked Questions

Why did Excel suddenly start blocking my macros?

Microsoft recently updated Office security policies to block macros in files downloaded from the internet by default. This 'Mark of the Web' update was implemented to protect users from malicious attacks, specifically ransomware and malware distributed via email attachments.

How can I tell if a macro-enabled file is safe to unblock?

You should only unblock a file if you are absolutely certain of its origin. Confirm with the sender through a secondary communication channel if you received it via email, ensure it comes from a reputable website, and scan the file with updated antivirus software before opening it.

Is it possible to disable this internet macro block globally?

While it is possible for IT administrators to disable this block via Windows Group Policy, it is highly discouraged for regular users due to severe security risks. Using Trusted Locations or unblocking individual files via Windows Properties is the recommended and safest approach.

I don't see the 'Unblock' checkbox in File Properties. What should I do?

If the 'Unblock' option is missing, it usually means the file does not have the 'Mark of the Web' tag. Ensure the file isn't stored on a network drive or inside a ZIP archive that hasn't been fully extracted. Extract the file to a local folder first, then check the properties again.

Excel & Data Problems