A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Reopen Excel and recover the affected workbook before troubleshooting the freeze, because ending the Excel task may have left an AutoRecover copy containing your latest changes.
1. Recover and verify the workbook
- Reopen Excel.
- If the Document Recovery pane appears, open the newest recovered version and immediately use Save As to save a separate copy.
- If the pane does not appear:
- Open File → Info → Manage Workbook.
- For a previously saved workbook, select the version marked (when I closed without saving), inspect it, and select Restore.
- For a new unsaved workbook, select Recover Unsaved Workbooks, open the latest copy, and then select Save As. ^1^
- Check both the replaced data and orange formatting before overwriting the original workbook.
Also open the other workbooks that were active during the freeze. They may have separate recovered versions.
2. Determine whether this was a one-time freeze
Open the recovered copy normally and perform a small manual edit. If Excel now works, no repair is required yet. Save frequently while checking the workbook.
The freeze occurring after a Copilot operation does not by itself establish that Copilot caused it. If it happens again—especially without using Copilot—isolate Excel’s add-ins and startup configuration.
3. If Excel freezes again, test Safe Mode
On Windows:
- Press Windows key + R.
- Enter:
excel /safe
- Select OK, open a copy of the affected workbook, and repeat a small edit.
- If Excel works in Safe Mode:
- Go to File → Options → Add-ins.
- At the bottom, select COM Add-ins → Go.
- Clear every checkbox and restart Excel normally.
- Re-enable add-ins one at a time, restarting Excel after each one, until the problem returns.
Safe Mode bypasses Excel add-ins, most COM add-ins, startup folders, and certain custom settings, making it the supported isolation test for recurring hangs. ^2^
If Excel also freezes in Safe Mode, proceed to repair rather than changing the registry manually.
4. Repair Microsoft 365 if Safe Mode does not help
- Windows 11: Right-click Start → Installed apps → Microsoft 365 → … → Modify.
- Windows 10: Right-click Start → Apps and Features → Microsoft 365 → Modify.
Start with Quick Repair. If the issue remains, repeat the process and choose Online Repair, which is more comprehensive. Repair applies to the whole Office suite, not only Excel, and a restart might be required. ^3^
5. Reduce the risk of losing future work
In Excel, open File → Options → Save and enable:
- Save AutoRecover information every x minutes
- Keep the last AutoRecovered version if I close without saving
For files stored in OneDrive or SharePoint, AutoSave can continuously save changes. For other locations, continue using Ctrl+S regularly. ^4^
If the freeze is reproducible only when issuing the same Copilot request, retain an unaffected workbook copy and report the issue to your organization’s Microsoft 365 administrator with the Excel version, Windows version, workbook storage location, approximate freeze time, and exact Copilot prompt.
References