Fix Excel Crashes After Macros Are Blocked in Windows 11
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.

- 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.
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.
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.
Ensure that Microsoft Excel is completely closed and not running in the background.
Open Windows File Explorer and navigate to the folder containing the problematic Excel workbook.
Right-click the Excel file and select 'Properties' from the context menu.
In the 'General' tab, look for the 'Security' section at the bottom. Check the box next to 'Unblock'.
Click 'Apply', then 'OK' to save the changes. Double-click the file to reopen it safely in Excel.

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. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
- 2. Install the application: Run the setup file and follow the on-screen instructions to install the suite on your Windows 11 PC.
- 3. Open your workbooks: Launch WPS Spreadsheets and open your .xlsx or .xlsm files seamlessly.

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.




