How to Fix Excel Macro Blocking for Downloaded Internet Files
Question details
Users are unable to run macros in Excel files downloaded from the internet because Windows blocks them for security reasons, sometimes enforced by conflicting work or school account policies.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to open and run a macro-enabled Excel file downloaded from an online source or email.
- Observed behavior
- Excel displays a security risk warning and completely blocks the macros from running. The user cannot enable them even with administrator access or a personal Microsoft 365 subscription.
Before attempting to unblock macros, ensure that the downloaded file is from a verified and trusted source, as malicious macros can severely compromise your system's security.
Disconnect Conflicting Work or School Accounts
Organizational security policies from connected work or school accounts can override your personal macro settings. Disconnecting them can restore your control.
If your personal computer is linked to a former employer, a school, or a web-hosting provider, Windows may enforce their strict IT security policies on your device. This often results in macros being blocked system-wide.
Press the Windows key + I on your keyboard to open the Windows Settings app, then click on 'Accounts'.
In the left-hand menu pane, scroll down and select 'Access work or school'.
Locate any extra or unwanted connected accounts. Click on the account name to expand the options, and choose 'Disconnect'. Follow the on-screen prompts to remove it from your PC.

Manually Unblock the File in Windows Properties
Windows applies a 'Mark of the Web' to downloaded files. You can manually unblock individual trusted files to allow macros to run.
Add the Download Folder to Excel's Trusted Locations
If you frequently download safe macro files to a specific folder, you can mark that folder as a Trusted Location in Excel.
Experience Hassle-Free Spreadsheets with WPS Office
Dealing with strict Microsoft Office security policies and Windows account conflicts can be frustrating. WPS Office offers a lightweight, free, and highly compatible alternative for your daily spreadsheet tasks without the complex policy barriers.
- 1. Download the software: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the installer and follow the simple on-screen instructions to complete the setup in minutes.
- 3. Open your spreadsheets: Launch WPS Spreadsheet and open your existing Excel files to start working immediately with full format compatibility.

Frequently Asked Questions
Why does Excel automatically block macros in files I download?
To protect your computer from malware, Windows adds a hidden tag called 'Mark of the Web' to files downloaded from the internet. When Excel detects this tag, it automatically blocks macros from running as a security precaution.
How do I know if an Excel macro is safe to run?
You should only enable macros if you completely trust the source of the file. If the file was sent by an unknown contact, downloaded from an unverified website, or looks suspicious, do not enable the macros.
Can I disable the macro security warning permanently?
While you can change Trust Center settings in Excel to 'Enable all macros', this is highly discouraged by security experts. Doing so leaves your computer highly vulnerable to potentially dangerous code running without your permission.
Why are my personal Microsoft 365 macro settings not applying?
If your personal PC is connected to a work or school account in Windows Settings, the organization's IT security policies can override your personal Microsoft 365 settings, enforcing strict macro blocking across your entire device.




