VBA & Macro Problems

Fix Excel Crashes After Macros Are Blocked in Windows 11

Kushani NimanthikaKushani Nimanthika Oct 10, 2026 870 views

Question details

The user experiences sudden application crashes in Microsoft Excel on Windows 11 when the software attempts to block potentially dangerous macros, particularly in workbooks created in older versions of Excel.

How to Fix Excel Crashes After Macros Are Blocked in Windows 11
Product
Microsoft Excel
Device & OS
Windows 11
Scenario
Opening a macro-enabled workbook downloaded from the internet or received via email, which triggers Microsoft 365's security block.
Observed behavior
Excel abruptly crashes, closes unexpectedly, or freezes immediately after blocking the macros in the legacy workbook.
Before you start

Verify that you absolutely trust the source and sender of the Excel workbook before proceeding, as enabling untrusted macros can expose your computer to malicious software.

Solution 1Recommended

Unblock the Excel File from Windows Properties

Use the Windows File Explorer properties menu to manually remove the security block on the trusted file, which prevents Excel from crashing upon opening.

Windows 11 marks files downloaded from the internet with a 'Mark of the Web'. Microsoft 365 automatically blocks macros in these files. Removing this block manually on trusted files bypasses the conflict that causes Excel to crash.

1
Close Microsoft Excel

Ensure that Microsoft Excel is completely closed and not running in the background.

2
Locate the file

Open Windows File Explorer and navigate to the folder containing the problematic Excel workbook.

3
Open File Properties

Right-click the Excel file and select 'Properties' from the context menu.

4
Check the Unblock option

In the 'General' tab, look for the 'Security' section at the bottom. Check the box next to 'Unblock'.

5
Apply and reopen

Click 'Apply', then 'OK' to save the changes. Double-click the file to reopen it safely in Excel.

Unblock the Excel File from Windows Properties
Security Warning: If the 'Unblock' checkbox is not visible, the file is not blocked by Windows, and the crash may be caused by a different VBA compatibility issue.
Free Microsoft Office alternative

Experience Stable Spreadsheet Management with WPS Office

If Microsoft Excel continues to crash or freeze when handling complex or legacy workbooks, consider switching to WPS Office. It provides a lightweight, highly stable environment for all your spreadsheet needs without sudden interruptions.

  1. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
  2. 2. Install the application: Run the setup file and follow the on-screen instructions to install the suite on your Windows 11 PC.
  3. 3. Open your workbooks: Launch WPS Spreadsheets and open your .xlsx or .xlsm files seamlessly.
Free, lightweight, and fast-loading spreadsheet application.Highly compatible with Microsoft Excel formats including .xls, .xlsx, and .xlsm.Stable performance when opening legacy or complex workbooks.Familiar user interface ensuring seamless migration and zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Excel crash instead of just showing a security warning?

When Excel attempts to block active macro content in files created with older versions of Excel, conflicts between modern security protocols and legacy code can cause memory faults, leading the application to terminate unexpectedly.

Can I permanently disable the macro security block in Excel?

While you can lower your macro security settings in the Trust Center, it is highly discouraged. Doing so leaves your system completely vulnerable to malicious scripts, viruses, and ransomware embedded in untrusted documents.

What if the 'Unblock' option is missing in the file properties?

If the Unblock option is absent, the file might not have a 'Mark of the Web'. In this case, try moving the file to a designated 'Trusted Location' configured within Excel's Trust Center settings to bypass the block.