Fix Disabled Macros in Excel for Microsoft 365 After Enabling Content
Question details
The user needs to determine why Excel still reports disabled macros after enabling content and adding the workbook location as trusted.
- Product
- Excel for Microsoft 365
- Device & OS
- Windows 10
- Scenario
- Opening a macro-enabled workbook whose content has already been enabled and whose folder has been added to trusted locations.
- Observed behavior
- A macro-disabled warning continues to appear despite the user's trust and content settings.
Confirm that the workbook comes from a trusted source before allowing its macros to run. Record the exact warning text and identify whether it appears inside Excel or in a separate security-software window.
Check Excel macro settings, the trusted folder, and downloaded-file blocking
Use this approach when the warning appears in Excel and the workbook should be allowed to run trusted macros.
Enabling content does not override every security restriction. A downloaded-file block, an incorrect trusted-folder path, or an organization-managed policy can prevent macros from running.
In Excel, select File > Options > Trust Center > Trust Center Settings > Macro Settings. Review the selected setting. For normal use, keep VBA macros disabled with notification rather than enabling all macros globally. If the settings are locked or managed by your organization, contact your IT administrator.
In Trust Center Settings, select Trusted Locations. Compare the listed folder with the workbook's actual location in File Explorer. If the workbook is in a subfolder, check whether the trusted-location entry allows subfolders. Use Add new location only for a controlled folder containing files you trust.
Close the workbook. In Windows File Explorer, right-click the workbook and select Properties > General. If an Unblock checkbox appears, select it only after verifying the file's source, then click Apply > OK. If Unblock is absent, proceed with the other checks.
Open the workbook again from the verified folder. If Excel displays a standard security warning with an Enable Content button, use it only for the trusted workbook. If the message instead says Microsoft has blocked macros because the source is untrusted, check the file block and trusted-location settings rather than enabling all macros.

Identify antivirus or firewall alerts separately from Excel warnings
Use this approach when a warning appears outside Excel or continues after Excel's trust settings have been verified.
Use WPS Spreadsheet for Everyday Workbook Editing
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for an easy transition. Use WPS Spreadsheet for everyday workbook viewing and editing; it does not repair Excel's macro security settings, and VBA support depends on the WPS edition and environment.

Frequently Asked Questions
Why are macros still disabled after I click Enable Content?
Enable Content does not override every restriction. Check File > Options > Trust Center > Trust Center Settings for macro settings and trusted locations, then check the workbook's Windows Properties for an Unblock option. An organization policy or separate security application may also be responsible.
Why does my trusted location not allow the workbook's macros?
The workbook may be outside the exact folder listed in Trust Center > Trusted Locations, or it may be in a subfolder that the entry does not cover. Compare the actual file path with the trusted-location entry. Network locations and organization policies can impose additional restrictions.
Should I enable all macros to remove the warning?
No. Enabling all macros globally can allow malicious code to run and may not resolve policy or security-software blocks. Use notification-based macro settings and approve only verified workbooks through an appropriate trust method.
Where is the Unblock option for a downloaded Excel workbook?
Close the workbook, right-click it in Windows File Explorer, and select Properties > General. If Windows has marked the file as downloaded from another source, an Unblock checkbox may appear near the bottom. Use it only after verifying the file's source.
Can WPS Office fix Excel's disabled-macro warning?
No. WPS Office does not change Excel's Trust Center settings or Microsoft Office security policies. WPS Spreadsheet can be an alternative for everyday workbook tasks, but confirm VBA support in your specific WPS edition before relying on macro-dependent workflows.




