'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Macros Blocked Even When Enabled in Settings
Question details
The user needs to execute macros in an Excel workbook, but the macros remain blocked despite macro settings being explicitly enabled in the software.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening an Excel workbook containing macros that was downloaded from the internet or received as an email attachment.
- Observed behavior
- Macros are restricted from running due to a Windows security feature, overriding the user's manual preference to enable macros in Excel settings.
Verify that the downloaded file or email attachment comes from a completely trusted source, as unblocking and running macros in unsafe workbooks can expose your computer to malware.
Unblock the File in Windows File Explorer Properties
Manually remove the security block applied by Windows to files originating from external sources before opening them in Excel.
Windows applies a 'Mark of the Web' to files downloaded from the internet or received via email. This overrides Excel's Trust Center settings and blocks macros by default until you manually verify the file is safe.
Ensure that the blocked workbook is completely closed in Microsoft Excel before proceeding.
Navigate to the folder on your computer where the downloaded workbook or saved email attachment is located.
Right-click the Excel file and select 'Properties' from the context menu.
In the General tab, look for a Security section at the bottom. Check the box labeled 'Unblock', then click 'Apply' followed by 'OK'.
Launch Microsoft Excel, open the workbook, and test your macros to confirm they now run successfully.
Re-download the Workbook and Modify Trust Options
Use this method if the original file is corrupted, cached incorrectly, or missing the manual unblock option.
Seamlessly Open and Edit Spreadsheets with WPS Office
If you are frustrated by complicated security restrictions and blocked macros in Microsoft Excel, consider trying WPS Office. It provides a lightweight, highly compatible alternative for managing your spreadsheets with an interface you already know.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your computer.
- 2. Launch WPS Spreadsheets: Open WPS Office and select the Spreadsheets module from the main dashboard.
- 3. Open Your Workbook: Click 'Open' and browse for your spreadsheet to immediately start viewing and editing your data.
Frequently Asked Questions
Why does Excel block macros even when enabled in the Trust Center?
Microsoft recently updated its security policies to automatically block macros in files that originate from the internet or email attachments (an invisible tag known as the 'Mark of the Web'). This operating system-level block overrides your local Excel Trust Center settings to protect you from malware.
What is the 'Unblock' option in File Explorer?
The 'Unblock' checkbox is a Windows feature that removes the 'Mark of the Web' from a downloaded file. Checking it tells the operating system and Microsoft Office that you explicitly trust the file and it is safe to execute its embedded macros.
Can I automatically unblock macros for all downloaded files?
While you cannot disable the Windows Mark of the Web globally due to severe security risks, you can set up a 'Trusted Location' in Excel's Trust Center. Any file saved into or moved to that specific folder will automatically bypass the macro block.
What should I do if the 'Unblock' checkbox is missing in Properties?
If the 'Unblock' option is not visible, the file is not blocked by Windows. If macros still do not run, double-check that your Excel Trust Center macro settings are actually enabled, or verify that the VBA code itself does not contain errors.
