Fix an Excel XLSM File Stuck at 0% When Opening
Question details
The user needs to open an XLSM workbook that no longer loads in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening a macro-enabled workbook that previously worked.
- Observed behavior
- Excel remains at 0% while opening the workbook.
Check whether other workbooks open normally in Excel and locate the affected XLSM file. The Safe Mode and Office repair steps below apply to Windows.
Open Excel in Safe Mode and disable add-ins
Use Safe Mode to check whether an add-in or startup component is preventing the workbook from opening.
Press Windows+R, enter excel /safe, and select OK.
In Excel, select File > Open > Browse and choose the affected XLSM file.
If the workbook opens, go to File > Options > Add-ins. Select COM Add-ins in the Manage list, click Go, and clear the add-ins. Repeat for Excel Add-ins.
Restart Excel normally and open the workbook again. If the problem persists, check Excel startup folders such as XLSTART for files that load automatically, and move suspected files out temporarily.

Repair the workbook with Excel Open and Repair
Try this if the workbook may be damaged or still does not open in Safe Mode.
Repair Office or restore an earlier workbook version
Use these options if Excel itself may need repair or the workbook remains damaged.
Try WPS Spreadsheets as an Excel alternative
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheet files. It may help you access workbook content, though it does not repair Excel's startup components and macro support can vary.

Frequently Asked Questions
Why does an XLSM file get stuck at 0% in Excel?
The workbook may be damaged, or an add-in or startup component may be interfering. Open Excel with Windows+R > excel /safe to check whether it loads without those components.
How do I repair an XLSM file that will not open?
In Excel, go to File > Open > Browse, select the file, click the arrow next to Open, and choose Open and Repair.
What if Open and Repair cannot fix the workbook?
Try Extract Data from the Open and Repair dialog, or restore an earlier copy from a backup or OneDrive Version history. Extract Data may not preserve macros or all workbook features.
Will opening the file in WPS fix Excel?
No. WPS Spreadsheets is an alternative for working with compatible spreadsheet files; it does not repair Excel or its add-ins. Macro behavior may differ, so check compatibility before relying on VBA features.




