Excel closed on its own and my progress wasn't autorecovered

Dan Gilmour 0 Reputation points
2026-10-05T15:34:21.72+00:00

I turned away to talk to a coworker with several excel sheets open and my unsaved sheet I'd been working on for hours closed. Specific complaints:

  1. Excel randomly closed
  2. Can't access auto-recover sheets from Excel home, have to open a random sheet to get access to the panel
  3. Auto-recover doesn't allow me to sort by recently worked on, doesn't seem to have any sorting method at all
  4. Sheets sometimes don't auto-recover. Every other application I use auto-saves in some way except this, and I've come to rely on the feature. The fact that it works often but not always makes us rely on it just for it to fail when it is needed.

Can you fix these issues?

Microsoft 365 and Office | Excel | For business | Windows
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-10-05T15:34:38.1766667+00:00

    What can be addressed from the available guidance:

    1. Improve recovery protection going forward In Excel on Windows, go to File > Options > Save and confirm these are enabled:
      • Save AutoRecover information every x minutes
      • Keep the last autorecovered version if I close without saving
      The documented default AutoRecover interval is 10 minutes. A smaller interval such as 5 or 10 minutes reduces how much work can be lost after an unexpected close.
    2. Check for recoverable versions For previously saved workbooks:
      • Go to File > Info
      • Look under Versions
      For newly created unsaved workbooks:
      • Go to File > Info > Manage Versions > Recover Unsaved Workbooks
      If the Document Recovery pane appears, review the listed files and use the timestamps to identify the newest version. Available actions can include Open/View, Save As, and Delete.
    3. Important limitation AutoRecover is not the same as continuous AutoSave. Microsoft guidance states that the Save button or Ctrl+S is still important, and continuous AutoSave is intended for Microsoft 365 files stored in OneDrive or SharePoint. For local files, AutoRecover is on by default and saves work periodically rather than continuously.
    4. About the specific complaints
      • “Excel randomly closed”: the available guidance confirms recovery steps after an unexpected shutdown, but it does not provide a documented fix for the cause of random closing in this scenario.
      • “Can’t access auto-recover sheets from Excel home”: no supported guidance was provided for changing that behavior.
      • “Auto-recover doesn’t allow sorting”: no supported guidance was provided for sorting recovered files.
      • “Sheets sometimes don’t auto-recover”: documented behavior shows recovery depends on whether AutoRecover had saved a recovery copy before the close. If the interval is 10 minutes, the most recent work since the last recovery point can be missing.
    5. Best practical setup
      • Store workbooks in OneDrive or SharePoint when possible
      • Turn on AutoSave for those cloud files
      • Keep AutoRecover enabled in File > Options > Save
      • Use Ctrl+S regularly for local files or critical edits
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Jay1 Tran 1,700 Reputation points Independent Advisor
    2026-10-05T16:23:41.2+00:00

    Hi Dan,

    An unexpected Excel closure can cause significant disruption, especially when the workbook contains several hours of unsaved work. To resolve the issue, please follow these steps:

    1. Recover the Unsaved Workbook

    Please try these steps before creating or editing additional workbooks:

    • Open Excel and select File > Info.
    • Select Manage Workbook > Recover Unsaved Workbooks.

    User's image

    • Review the available files and check the date and time shown for each one.

    User's image

    • Open the most recent version, then immediately select File > Save As and save it with a new name.
    1. Configure AutoRecover

    To reduce the amount of work that could be lost in the future:

    • In Excel, select File > Options > Save.
    • Enable Save AutoRecover information every and set the interval to 5 minutes.
    • Enable Keep the last AutoRecovered version if I close without saving.

    User's image

    • Note the AutoRecover file location shown on the same page.
    • Select OK, restart Excel, and confirm that the settings remain enabled.
    1. Use AutoSave for Future Workbooks

    For more consistent protection, save important workbooks to OneDrive for Business or SharePoint Online in .xlsx format and confirm that the AutoSave switch is enabled.

    AutoSave can save supported Microsoft 365 files every few seconds and provides version history. Local files and CSV files do not receive the same level of protection.

    1. Launch Excel in safe mode and isolate add-ins
    • Press Windows + R.  
    • Type excel.exe /safe and select OK.  
    • If Excel opens without crashing, go to File > Options > Add-ins.  
    • At the bottom, next to Manage, select COM Add-ins and click Go.  
    • Clear all add-ins and select OK.  
    • Close Excel and open it normally.  
    • If the crashes stop, re-enable the add-ins one at a time until the problematic add-in is identified.
    1. Repair Office 
    • Close all Office applications (Word, PowerPoint, Excel, Outlook, etc.).    
    • Open Windows Settings (press Windows + I).    
    • Go to Apps > Installed apps.    

    User's image

    • Find Microsoft 365 / Microsoft Office in the list.   
    • Select the three dots (…) next to it and choose Modify.    

    User's image

    • If prompted by User Account Control, select Yes.   
    • Choose Online Repair > then select Repair.   

    User's image

    • Follow the on‑screen instructions until it completes.   

    I hope your issue gets resolved soon. Any updates would be greatly appreciated.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.