How to Open an Excel Workbook That Freezes Because of Macros
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.

- 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 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.
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.
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.
In Excel or WPS Spreadsheet, click File > Open, browse to the workbook, press and hold the Shift key, select the file, and click Open.
Do not release Shift until the workbook is fully open and the status bar stops updating, so automatic macros do not run.

Start Excel in Safe Mode to Bypass the Freezing Macro
Use Safe Mode when Shift alone does not prevent the freeze and you need to isolate whether an add-in or startup macro is causing the problem.
Use Open and Repair or Recover the Workbook from a Backup
Use this when the workbook still freezes after using Shift or Safe Mode, or when the file has become corrupted and you need to restore a working 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. Download and open WPS Office Spreadsheet: Download WPS Office, launch WPS Spreadsheet, and click File > Open to select the frozen Excel workbook.
- 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. 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. 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.

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.




