VBA & Macro Problems

How to Open an Excel Workbook That Freezes Because of Macros

Phi Hung VoPhi Hung Vo Nov 13, 2026 869 views

Question details

The user needs to open an Excel workbook that freezes during startup because an automatic VBA macro runs or contains an error, and they need to access the file and save or recover its code.

How to Open an Excel Workbook That Freezes Because of Macros
Product
WPS Office Spreadsheet / Microsoft Excel workbook
Device & OS
not provided
Scenario
The user opens an Excel workbook that automatically runs VBA macros during startup, causing the application to freeze before the file becomes usable.
Observed behavior
The workbook freezes Excel or WPS Office while opening, preventing access to the data and VBA code.
Before you start

Before attempting any recovery method, close the frozen workbook completely and make sure the original file is saved in a known location. If possible, avoid repeatedly double-clicking the file while it is frozen because each attempt may launch another unresponsive process.

Solution 1Recommended

Hold Shift While Opening the Workbook to Stop Automatic Macros

Use this first when the workbook freezes immediately because a macro such as Auto_Open or Workbook_Open runs as soon as the file opens.

Holding the Shift key while opening an Excel workbook prevents automatic macro routines from running, letting the file load far enough to review data and code.

1
Close the frozen workbook

If Excel or WPS Office is unresponsive, close it completely or open Task Manager with Ctrl+Shift+Esc, select the application, and click End Task before reopening it normally.

2
Click File > Open and hold Shift

In Excel or WPS Spreadsheet, click File > Open, browse to the workbook, press and hold the Shift key, select the file, and click Open.

3
Keep holding Shift until the workbook finishes loading

Do not release Shift until the workbook is fully open and the status bar stops updating, so automatic macros do not run.

Hold Shift While Opening the Workbook to Stop Automatic Macros
Workbook opens without automatic macros: Once the file is open, go to the VBA editor or macro settings to review and disable the problematic macro before saving a clean copy.

Open the Excel Workbook in WPS Office Spreadsheet and Disable Problem Macros

Use WPS Office Spreadsheet to open the frozen Excel workbook, bypass the automatic macro, inspect the VBA code, and save a clean copy without the freezing routine.

  1. 1. Download and open WPS Office Spreadsheet: Download WPS Office, launch WPS Spreadsheet, and click File > Open to select the frozen Excel workbook.
  2. 2. Open the workbook without automatic macros: If a macro security warning appears, click Disable Macros or enable content only after confirming the file is safe.
  3. 3. Review the VBA code: Go to the Developer tab and click View Code or open the VBA editor to inspect the macro that runs during startup.
  4. 4. Save a clean copy: Click File > Save As, choose the Excel format you need such as .xlsx or .xlsm, and save a copy without the problematic automatic macro.
Opens Excel workbooks even when macros cause Excel to freezeLets you disable or skip problematic VBA macros before savingFull compatibility with .xlsx, .xlsm, and .xls Excel formatsFree, lightweight, and familiar spreadsheet interfaceSeamless migration from Microsoft Excel
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel workbook freeze as soon as I open it?

An automatic macro such as Workbook_Open or Auto_Open likely runs at startup and contains an error or takes too long. Hold Shift while opening, use Safe Mode, or open the file in WPS Office with macros disabled.

Does holding the Shift key stop every macro in Excel?

No. Holding Shift prevents automatic startup macros, but it does not disable macros assigned to buttons, shapes, or keyboard shortcuts. You may still need to open the VBA editor and remove the problematic macro.

Can WPS Office open a .xlsm workbook that freezes Excel?

Yes. WPS Spreadsheet can open Excel macro-enabled workbooks, and you can choose to disable macros when the security warning appears so the file loads without the freezing routine.

How do I remove the macro that makes my workbook freeze?

Open the workbook with macros disabled, then in Excel click Developer > Macros or press Alt+F11 to open the VBA editor, locate the automatic macro, and delete or comment out the code before saving.

Will Open and Repair recover a corrupted Excel workbook?

In most cases yes. In Excel click File > Open, select the file, click the arrow next to Open, choose Open and Repair, then choose Repair to recover the workbook or Extract Data to pull values only.