Sudden Excel Home shutdowns leave me with no listing of files that were open.

Question

Normally, if Excel shuts down and reopen when there were many files open before or at the time of the sudden shutdown, if we open a new blank page, we get a listing of the files that were open so we can decide what we want to keep or delete.

Now my system, so full of problems and issues is shutting down, suddenly for no known reason, but when i restart it, there is no listing of files in Excel that were open.

What can I do? Some of the files I know, but not all of them.

Answer 1

Hello,

Did you check the AutoRecover folder location in Excel settings?

Turn on AutoRecover in Excel. Go to File, Options, Save, then enable AutoRecover and note the file path. Open File, Open, Recover Unsaved Workbooks to find files. If nothing shows, run Quick Repair from Control Panel, Programs, Microsoft 365, Change, then select Quick Repair.

Answer 2

Excel relies on its built‑in recovery features to show the list of files that were open when a crash occurred. If that list is no longer appearing, focus on two areas:

1. Use Document Recovery when it appears

• After a crash, when Excel is restarted, a Document Recovery pane should appear listing recovered files.
• If that pane appears, follow the guidance in Recover your Office files (linked from the article below) to review, save, or discard each recovered file.

2. Reduce data loss risk in future crashes The behavior described (no list of open files after a crash) can occur if Excel cannot complete its recovery process. To minimize future data loss:

• Turn on and keep AutoRecover/AutoSave enabled for workbooks.
• Save files regularly to a reliable location (such as a local drive or a well‑connected cloud location) so that even if the recovery list does not appear, recent versions are still available.
• Address underlying stability issues on the device (unexpected system shutdowns, freezes, or crashes) so that Excel has a chance to write AutoRecover information and present the Document Recovery pane after restart.

If the system continues to shut down suddenly and Excel never shows the Document Recovery pane, the only available copies will be the last versions manually saved or any AutoRecover files that can be found by following the steps in Recover your Office files from the article below.

---

References:

• Help protect your files in case of a crash