Fix Excel Desktop Hanging When Opening a Shared Workbook
Question details
Resolve an issue where the Excel desktop app hangs while opening a specific shared workbook, even though other files open normally and the workbook works in Excel for the web.
- Product
- Microsoft Excel desktop application
- Device & OS
- Windows
- Scenario
- The user needs to open and work with a shared workbook in the desktop version of Excel.
- Observed behavior
- Excel desktop becomes unresponsive when opening the affected shared workbook, while Excel for the web opens it successfully.
Confirm that the workbook opens in Excel for the web and that other Excel files open normally on the same computer. Ask other collaborators whether they can open the shared workbook in the desktop app to determine whether the issue is local or file-specific.
Open Excel in Safe Mode and disable third-party add-ins
Use this method first when Excel freezes on opening a workbook, as COM or Excel add-ins can interfere with shared-file loading.
Safe Mode starts Excel without most custom add-ins and startup extensions. If the workbook opens in Safe Mode, re-enable add-ins one at a time to identify the conflicting item.
Press Windows+R, type excel /safe, and select OK. In Excel Safe Mode, open the shared workbook from File > Open.
If the workbook opens without hanging, close Excel and reopen it normally to begin testing add-ins.
In Excel, select File > Options > Add-ins. At the bottom, choose COM Add-ins from the Manage list, select Go, clear all check boxes, and select OK.
Restart Excel normally and open the workbook. If it works, return to File > Options > Add-ins > Manage: COM Add-ins > Go and enable one add-in at a time until the issue returns.
Create a clean workbook and move the affected sheets or data
Use this option when only one workbook causes Excel desktop to stop responding, which can indicate workbook corruption or problematic content.
Verify access, restore an earlier version, and test the Windows profile
Use these checks when Safe Mode does not help or when the issue may be tied to the shared file location, version history, or a damaged local Excel profile.
Open and edit the shared workbook with WPS Office Spreadsheets
If Microsoft Excel desktop continues to hang on the shared workbook, try WPS Office as a free, lightweight spreadsheet alternative. WPS Spreadsheets provides a familiar ribbon-style interface and can open, edit, and save common Excel files for a smooth transition.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the application home screen.
- 2. Open the affected workbook: Select Open and choose the shared .xlsx or .xls workbook from its synced OneDrive, SharePoint, or local folder.
- 3. Review and edit the file: Check worksheets, formulas, and shared data in WPS Spreadsheets, then make any necessary edits.
- 4. Save in Excel format: Select Menu > Save As and choose Excel Workbook (*.xlsx) to retain compatibility for collaborators using Microsoft Excel.
Frequently Asked Questions
Why does a workbook open in Excel for the web but freeze Excel desktop?
Excel for the web and Excel desktop use different loading components. A desktop-only add-in, startup setting, cached connection, local profile issue, or unsupported workbook object can cause the desktop app to hang while the web version opens the same file.
How do I open Excel in Safe Mode?
Press Windows+R, enter excel /safe, and select OK. Then use File > Open to test the shared workbook. Safe Mode prevents most add-ins and custom startup items from loading.
Where can I disable Excel add-ins?
In Excel, go to File > Options > Add-ins. Choose COM Add-ins in the Manage box, select Go, clear the enabled add-ins, and select OK. Restart Excel and test the workbook again.
Can I restore a previous version of a shared Excel workbook?
Yes. In OneDrive or SharePoint, select the workbook and choose Version history. Open a previous version to test it, or restore a version that existed before the desktop freezing started.
What should I look for in Windows Event Viewer when Excel freezes?
Open Event Viewer and go to Windows Logs > Application. Check Error entries created at the time of the freeze, especially events that mention Excel, Office, Application Error, or a named add-in module.
