'%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 Microsoft Excel Blocked Macros Security Warning
Question details
The user needs to enable macros on an Excel template from a trusted source, but Excel displays a security warning blocking the macros, even after removing the file block in Windows Properties.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening a macro-enabled Excel template obtained from an external trusted source.
- Observed behavior
- Excel displays a warning that macros have been blocked, preventing the template from functioning correctly, and unblocking via Windows Properties does not resolve the issue.
Ensure you absolutely trust the source of the macro-enabled file before proceeding. Malicious macros can severely harm your computer, so never enable them for files from unknown origins.
Add the Template's Folder to Excel Trusted Locations
By adding the folder where your template is saved to Excel's Trusted Locations, you bypass the standard security blocks and allow macros to run safely.
When removing the 'Mark of the Web' block from Windows Properties isn't enough, Microsoft Excel relies on its internal Trust Center to determine safe files. Adding a specific folder to Trusted Locations instructs Excel to trust any file opened from that directory.
Launch Microsoft Excel, click on 'File' 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.
In the Trust Center window, select 'Trusted Locations' from the left-hand menu to view your currently trusted folders.
Click the 'Add new location' button at the bottom. Click 'Browse' to locate the folder where your trusted macro-enabled template is saved.
Check the box for 'Subfolders of this location are also trusted' if applicable. Click 'OK' on all dialog boxes to save your new settings. Open your file from this folder to use it without macro warnings.
Try WPS Office for Seamless Spreadsheet Management
If you are frustrated by complex Trust Center settings and persistent macro blocks in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly alternative for managing all your spreadsheets securely.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package.
- 2. Install the Software: Run the installer and follow the on-screen prompts to complete the setup on your Windows device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing files to manage your data with ease.
Frequently Asked Questions
Why does Excel still block macros after I unblocked the file in Properties?
Microsoft Office employs strict security protocols for files originating from the internet. Even if you remove the 'Mark of the Web' in Windows Properties, Excel's Trust Center may still block macros if the file is not in a Trusted Location or if your global macro settings are set to disable them.
What is a Trusted Location in Excel?
A Trusted Location is a specific directory on your computer or network that you designate as safe. Files opened from a Trusted Location bypass standard Trust Center security checks, allowing macros and active content to run automatically without warnings.
Is it safe to enable all macros in Trust Center?
No. It is highly recommended to keep the setting 'Disable all macros with notification' enabled. Automatically enabling all macros exposes your computer to significant security risks, as malicious scripts could run without your permission.
