Security Policy Errors

How to Fix Excel Macro Security Warnings When Unblock is Missing

Phi Hung Vo Oct 16, 2026 869 views

Question details

The user is unable to run macros in an Excel file due to a security warning, and the standard Unblock option is missing from the file properties.

How to Fix Excel Macro Security Warnings When Unblock is Missing

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to open and run a macro-enabled Excel file that is centrally located on a network share or downloaded from the internet.
Observed behavior: Excel displays a security warning blocking the macro, macro execution produces an error, and the Windows file properties dialog lacks the Unblock checkbox.

Before you start

Verify that you completely trust the source of the Excel file and the network drive it resides on, as enabling macros can potentially expose your computer to malicious code.

Solution 1Recommended

Add the File's Folder to Excel Trusted Locations

Use this method to bypass the missing Unblock option by explicitly telling Excel to trust the folder or network share where your file is located.

When Microsoft Office blocks macros by default, it usually expects you to unblock the file via its properties. However, for files on network shares or certain drives, this option may disappear. Adding the location directly to the Trust Center resolves this.

Open Trust Center Settings

Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom. In the Excel Options window, click 'Trust Center' on the left pane, then click the 'Trust Center Settings' button.

Navigate to Trusted Locations

In the Trust Center window, select 'Trusted Locations' from the left sidebar. If your file is on a network drive, ensure you check the box at the bottom that says 'Allow Trusted Locations on my network (not recommended)'.

Add the Network Drive Path

Click the 'Add new location' button. Click 'Browse' to locate your folder (for example, your network share F:\CCM\PRODUCTION CTL -SCRAPS) or manually type the path into the field.

Include Subfolders and Save

Check the box for 'Subfolders of this location are also trusted' if your Excel files are organized in deeper folders. Click 'OK' on all dialog boxes to save your changes, then reopen the Excel file to run the macro.

Add the File's Folder to Excel Trusted Locations

Network Paths: If a mapped drive letter (like F:\) does not work, try adding the actual UNC network path (e.g., \\ServerName\ShareName) to the Trusted Locations.

Solution 2

Add the Network Share to the Local Intranet Zone

If Excel still considers your network drive to be an internet location, you can reclassify the drive in your Windows Internet Options.

Free Microsoft Office alternative

Open and Edit Spreadsheets Smoothly with WPS Office

If you are frequently dealing with strict Microsoft Office security policies and missing Unblock options, consider trying WPS Office. It provides a lightweight, highly compatible environment for opening your workbooks, editing data, and managing spreadsheets without unnecessary friction.

1. Download WPS Office: Visit the official WPS Office website to download the free installation package for your operating system.
2. Install and Launch: Run the installer to complete the setup, then open WPS Spreadsheet.
3. Open Your Workbook: Navigate to File > Open to select your network or downloaded spreadsheet and begin editing with full compatibility.

Seamless format compatibility with Microsoft Excel (.xlsx, .xls, .xlsm).Free and lightweight application that installs in seconds.Familiar user interface with a zero learning curve for Excel users.Built-in tools for advanced data analysis and visualization.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel block macros in downloaded files by default?

Microsoft blocks macros from the internet by default to protect users from malicious code and ransomware. Files downloaded from the web or email receive a hidden 'Mark of the Web' (MotW) tag that triggers Excel to block macro execution automatically.

Where is the Unblock option usually located for an Excel file?

If available, the Unblock option is found by right-clicking the Excel file in Windows File Explorer, selecting 'Properties', and looking at the bottom of the 'General' tab next to the Security warning.

Why is the Unblock option missing from my file properties?

The Unblock option may be missing if the file is stored on a network share formatted with FAT32, if your organization's IT policies have restricted the option, or if the file was never actually tagged with the Mark of the Web but Excel still considers the location unsafe.

Microsoft Office Security Issues