Troubleshoot Excel File Errors and Workbooks That Won't Open
Question details
Identify and resolve Excel errors that prevent one or more workbooks from opening.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user needs to determine whether an Excel error affects a single workbook or the Excel application more broadly.
- Observed behavior
- Excel reports errors, stops working, or fails to open one or more workbooks.
Try opening a different workbook and note whether the error affects one file or all files. The troubleshooting steps below use Windows; menu names can vary by Office version.
Repair a Single Workbook That Won't Open
Use Excel's Open and Repair command when the problem is limited to one workbook.
In Excel, select File > Open > Browse and locate the affected workbook.
Select the workbook, click the arrow next to Open, and choose Open and Repair.
Choose Repair. If Excel cannot repair the workbook, repeat the process and choose Extract Data to try to recover values and formulas.

Check Excel Add-ins, Startup Files, and Windows Settings
Use these checks when multiple workbooks fail or Excel itself stops working.
Repair the Microsoft Office Installation
Repair Office if Excel fails across multiple workbooks or the startup checks do not resolve the issue.
Open Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files in WPS Spreadsheet for a straightforward transition, although WPS does not repair Microsoft Excel itself.

Frequently Asked Questions
How do I tell if the problem is with one workbook or Excel?
Open a different workbook in Excel. If only one file fails, try File > Open > Browse > Open and Repair. If several fail, check Safe Mode and repair Office.
What should I do if Excel opens in Safe Mode?
Go to File > Options > Add-ins, select COM Add-ins under Manage, and click Go. Disable the add-ins, restart Excel normally, and re-enable them one at a time to find a conflict.
Where can I check Excel startup files?
Press Windows+R and enter %appdata%\Microsoft\Excel to inspect the Excel folder, including XLSTART if present. Also check File > Options > Advanced > General for the 'At startup, open all files in' path.
What is the difference between Quick Repair and Online Repair?
Quick Repair attempts a faster local repair of Office. If it does not resolve the problem, select Online Repair from the Office Change menu in Programs and Features; it requires an internet connection.
Can WPS Office fix my Excel installation?
No. Use Office repair and Excel's troubleshooting options to fix Microsoft Excel. WPS Spreadsheet is an alternative for opening compatible XLS and XLSX files.




