Fix Blocked Excel Macros After Changing Security Settings
Question details
The user needs to make macros available in an Excel workbook that remains blocked after security settings and trusted locations were checked.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to run macros in a workbook after changing macro security settings and reopening the file.
- Observed behavior
- The macros remain unavailable, potentially because Excel does not trust the workbook's source or publisher.
Read the exact security message in Excel and confirm that you trust the workbook and its source before enabling any macros. Check that the file uses a macro-enabled format such as .xlsm; the Windows steps below may differ on other systems.
Unblock a Trusted Workbook Downloaded From the Internet
Use this method when Excel says macros are blocked because the file's source is untrusted.
Close the workbook in Excel, then locate the saved file in Windows File Explorer.
Right-click the workbook, select Properties, and look for an Unblock checkbox on the General tab.
If Unblock is available and you trust the file, select it, click Apply, and reopen the workbook in Excel.
If Excel displays a security warning, read it and use Enable Content only if you trust the workbook and the option is offered.

Verify the Workbook's Trusted Location and Format
Use this method if the workbook should open from a trusted folder but macros are still unavailable.
Check the Macro Publisher or Organization Policy
Use this method when the warning refers to a publisher, a digital signature, or settings managed by your organization.
Work With Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not change Microsoft Excel's macro security settings.

Frequently Asked Questions
Why are macros still blocked after I change Excel's macro settings?
Excel can block a file because it came from an untrusted source, even when macro settings have been changed. Read the security message and, on Windows, check the file's Properties > General tab for an Unblock option.
Does removing the workbook author unblock macros?
No. The author field under File > Info > Properties > Advanced Properties is document metadata; removing it does not establish publisher trust or remove a Windows download block.
How do I check whether a folder is trusted in Excel?
In Excel for Windows, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. Compare the listed paths and subfolder settings with the workbook's actual location.
Can an XLSX file contain VBA macros?
The standard XLSX format does not retain VBA macros. Use File > Save As and select Excel Macro-Enabled Workbook (.xlsm) for a workbook that needs VBA.
What if my organization blocks macros?
If Excel reports that the setting is managed by your organization, contact your IT administrator with the exact warning and the workbook's source. Organization policy may prevent you from changing the relevant setting.




