VBA & Macro Problems

Fix Excel Security Risk Error Blocking Macros in a Workbook

Emma BrownEmma Brown Nov 12, 2026 869 views

Question details

The user needs to allow macros in a trusted Excel workbook that is blocked by Excel's security risk warning.

Fix the Excel Security Risk Error That Blocks Workbook Macros
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.
Before you start

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.

Solution 1Recommended

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.

1
Close the workbook

In Excel, close the affected workbook and exit Excel if the file remains open.

2
Open the workbook Properties dialog

In File Explorer, right-click the .xlsm or .xlsb workbook and select Properties.

3
Remove the internet security mark

On the General tab, select Unblock in the Security section if it appears, then click Apply and OK.

4
Reopen and test the workbook

Open the workbook in Excel and select Enable Content only if you recognize and trust the macro source.

Unblock a trusted Excel workbook in file Properties
Use Unblock only for trusted files: If you did not expect the workbook or cannot verify its source, leave it blocked and ask the sender or your IT team to confirm it.
Free Microsoft Office alternative

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. 1. Download WPS Office: Select Download WPS Office Free and install WPS Office on your computer.
  2. 2. Open the workbook in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and use Open to select your Excel workbook.
  3. 3. Review workbook content: Check formulas, worksheets, formatting, and data before making edits or sharing the file.
Open and edit Microsoft Excel .xls and .xlsx workbook formats.Use a familiar spreadsheet interface for formulas, tables, charts, and everyday workbook tasks.Free and lightweight alternative for users moving from Microsoft Office.Maintain compatibility when sharing standard spreadsheet files with Excel users.
QA img-9

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.