Fix Excel Security Risk Error Blocking Macros in a Workbook
Question details
The user needs to allow macros in a trusted Excel workbook that is blocked by Excel's security risk warning.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a macro-enabled workbook received from the internet, email, shared storage, or another untrusted source.
- Observed behavior
- Excel displays a red security warning and prevents the workbook macros from running because the file is considered untrusted.
Confirm that the workbook and its sender are trustworthy before allowing any macros to run. Close the workbook in Excel before changing its file properties or Trust Center settings.
Unblock a trusted Excel workbook in file Properties
Use this option when the macro-enabled workbook was downloaded or received as an attachment and you trust its source.
Windows can mark files obtained from the internet or email as potentially unsafe. Removing this mark can allow Excel to evaluate the workbook's macros normally.
In Excel, close the affected workbook and exit Excel if the file remains open.
In File Explorer, right-click the .xlsm or .xlsb workbook and select Properties.
On the General tab, select Unblock in the Security section if it appears, then click Apply and OK.
Open the workbook in Excel and select Enable Content only if you recognize and trust the macro source.

Review Excel Trust Center macro and trusted location settings
Use this method when the file is trusted but Excel continues to block macros after the file has been saved locally.
Use a trusted digital signature or contact your administrator
Use this approach when macros are distributed to other users or when policy settings prevent changes on a work computer.
Open and Edit Excel Workbooks with WPS Office
If Microsoft Excel security settings or organizational restrictions are disrupting your workbook workflow, WPS Office provides a free, lightweight office suite with a familiar spreadsheet interface and straightforward migration for everyday Excel files. You can open, review, and edit compatible workbook content while keeping your existing file formats.
- 1. Download WPS Office: Select Download WPS Office Free and install WPS Office on your computer.
- 2. Open the workbook in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and use Open to select your Excel workbook.
- 3. Review workbook content: Check formulas, worksheets, formatting, and data before making edits or sharing the file.

Frequently Asked Questions
Why does Excel say that macros were blocked because the file came from an untrusted source?
Excel can block macros in files downloaded from the internet, received by email, or copied from certain shared locations. If you trust the file, close it, right-click it in File Explorer, choose Properties, select Unblock, and reopen it.
Where are macro security settings in Excel?
Go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Do not select Enable all macros unless your security administrator specifically instructs you to do so.
Can I make a folder trusted for Excel macro workbooks?
Yes. In Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, select Add new location, and choose a secured local folder for trusted workbooks.
Why is the Unblock option missing from the workbook Properties dialog?
The file may not have an internet security mark, or it may be stored in a location that does not support the setting. Check Excel Trust Center settings and ask IT to review policy restrictions if the warning continues.
What should I do if my company blocks Excel macros through policy?
Contact your IT administrator. Group Policy can override Excel Trust Center settings, so only an administrator may be able to approve a trusted location, publisher, certificate, or workbook source.




