Excel may block macros in an older workbook because Windows marked the file as coming from the internet or another restricted location. The warning is a security signal about the file’s origin, not proof that the workbook is malicious. If you need its macros, verify the file first, then unblock only that file or ask your IT team about a controlled option.
Why are my Excel macros blocked?
When a workbook is downloaded from a browser or received as an email attachment, Windows may attach a Mark of the Web (MOTW) marker. Office uses that marker to identify files from internet sources, and in supported Office for Windows versions, VBA macros in those files are blocked by default. An internal network share that Office does not recognize as a trusted location can also trigger a block. Microsoft describes VBA macros as a common way attackers deploy malware and ransomware, which is why the default is restrictive: Macros from the internet are blocked by default in Office.
The warning does not establish that this particular workbook is harmful. It means you should treat its code as untrusted until you verify where it came from and what it is meant to do. A familiar sender name alone is not enough; malicious files can impersonate people or organizations you know.
Do you need to enable the macros?
Usually, no. You can generally open a macro-enabled workbook and view its contents or make simple edits without running its macros. A macro-enabled Excel workbook commonly uses the .xlsm extension; a standard modern workbook without embedded VBA macros uses .xlsx. Microsoft’s guidance is to leave macros disabled unless you understand and need the functionality they provide: Enable or disable macros in Microsoft 365 files.
Free tools Windows power users keep installed
One-click scans. No signup required.
If the workbook’s visible data is all you need, keep macros disabled. If a feature such as an automated report or custom workflow depends on them, confirm the file’s source and purpose through a trusted channel before proceeding.
How do I unblock one trusted Excel file in Windows?
For a file you have independently verified, remove its internet-origin marker rather than lowering macro security for all of Excel:
- Close the workbook in Excel.
- In Windows File Explorer, right-click the workbook and select Properties.
- On the General tab, select Unblock if the checkbox is available.
- Select Apply, then OK, and reopen the workbook.
This removes the file’s Mark of the Web. Microsoft documents PowerShell’s Unblock-File command as an equivalent method, but use it only for a file you have verified. Unblocking does not override a separate Trust Center setting or organization policy. Microsoft’s steps are in its guidance on internet macros.
If there is no Unblock checkbox, or Excel still blocks the macros afterward, the file may be on a network location or another Trust Center or policy control may be responsible. Do not compensate by enabling every macro.
Rank #3
Which option is appropriate for a recurring workflow?
For repeated use, the right solution depends on how broadly code should be trusted and who manages the workflow. A wider trust scope needs stronger controls.
| Option | Scope | Who should manage it | Important trade-off |
|---|---|---|---|
| Unblock the individual file | One file | User, after verifying the file | Removes that file’s MOTW; another policy or setting can still block it. |
| Use a trusted location | Files placed in a designated folder | IT or a user following organizational controls | Files in trusted locations bypass Trust Center checks, so restrict write access and use these locations sparingly. |
| Trust a signed publisher | Code signed with that publisher’s certificate | IT or a user who has verified the publisher and certificate | Trust applies to all code signed with that certificate, not just one workbook. |
| Change macro settings | Excel application settings | IT if the device is managed | Broad settings can permit risky code; organization policy may prevent changes. |
Microsoft also documents trusted sites and network locations, but classifying a site as trusted can grant elevated permissions beyond Office. Have IT review the source and workflow before changing that classification. See Microsoft’s instructions for managing trusted publishers and Excel macro security settings.
Why does Excel say the source is untrusted even on a work network?
A network share is not automatically trusted just because it is internal. If Office does not classify it as Local intranet or a Trusted site, files there can still be blocked. Ask IT to assess the share and workflow rather than moving workbooks into a broad trusted location yourself. Any trusted location should have limited write access, since anyone able to place files there may be able to put code that bypasses normal Trust Center checks.
What if the setting is locked or the warning persists?
You can inspect Excel’s macro controls at File > Options > Trust Center > Trust Center Settings > Macro Settings. These settings apply to Excel, not every Office application. If the controls are unavailable or managed by your organization, contact IT instead of trying to override the configuration. Microsoft explains the available controls in Change macro security settings in Excel.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →- If the file came from a browser or email, check its Properties for an Unblock option.
- If it is on a network share, ask whether the location is intentionally classified as trusted.
- If the workbook remains blocked after a per-file unblock, ask IT whether policy or another Trust Center setting applies.
- If the file is an add-in rather than a workbook, identify its type before changing settings; Excel add-ins can have extra restrictions.
Are VBA macros, Excel 4.0 macros, and add-ins treated the same?
VBA macros
The common internet-macro warning concerns VBA macros in Office files marked as coming from the internet. A per-file unblock removes that origin marker, but does not guarantee that other controls will permit the code to run.
Excel 4.0 (XLM) macros
Excel 4.0 macros use a separate setting. Excel has a checkbox for allowing XLM macros when VBA macros are enabled, and Microsoft recommends migrating XLM macros to VBA. See Working with Excel 4.0 macros.
Excel add-ins
Do not assume that trusting a publisher will unblock every add-in. Microsoft notes that a trusted publisher alone does not unblock Excel .xla or .xlam add-ins carrying MOTW; an individual-file unblock or a trusted location may be needed. Because those options widen trust, use them only under the same verification and access controls as for workbooks.
Does this block apply to Excel for Mac or the web?
Microsoft’s documented internet-macro default applies to Office applications on Windows, including Excel. Microsoft says the change does not affect Office for Mac, Android or iOS, or Office on the web. The rollout varied by application and update channel: for Excel and several other apps, Microsoft lists Current Channel version 2206 beginning July 27, 2022, and Current Channel Preview version 2203 beginning April 12, 2022. Other channels and applications had separate rollout dates. Organization policies and existing Trust Center settings can also affect what happens.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesMicrosoft’s version and platform details are in the internet-macro documentation.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
