i lost a lot of data after suddenly the excel automatically closed

Reopen Excel immediately and save the newest copy shown in the Document Recovery pane before closing or deleting any recovered versions.

Recover the lost work

1. Open Excel again.
2. If Document Recovery appears on the left:
   • Compare the date and time shown for each version.
   • Open the newest version and check whether it contains the missing data.
   • Select Save As and save it with a new name in a known folder.
   • If uncertain about another recovered version, keep it; do not select Delete or choose the option that removes recovered files. Excel normally opens Document Recovery after an unexpected closure and may show the latest saved, AutoSaved, or AutoRecovered copies.^1^

If Document Recovery does not appear

If the workbook had previously been saved:

1. Open the workbook.
2. Select File → Info.
3. Under Manage Workbook, look for a version marked (when I closed without saving).
4. Open it, verify the missing data, and select Restore.
   Restore overwrites the current saved version, so use Save As first if you need to preserve both copies.^2^

If the workbook had never been saved:

1. Select File → Info → Manage Workbook → Recover Unsaved Workbooks.
2. Open the most recent matching file.
3. Select Save As immediately.^2^

If the workbook was stored in OneDrive or SharePoint

Check its Version History, because files stored there can have previous versions:

1. Locate the workbook in OneDrive or SharePoint.
2. Open its Version history.
3. Select a version created before Excel closed.
4. Review it and restore the appropriate version.

AutoSave and Version History apply to files stored in OneDrive or SharePoint in Microsoft 365.^3^

If no recovery copy exists

The missing changes might not be recoverable. AutoRecover only contains information saved at its configured interval; for example, a 15-minute interval may omit up to the last 14 minutes of work.^4^

To reduce future loss:

1. Go to File → Options → Save.
2. Enable Save AutoRecover information every x minutes.
3. Set a short interval such as 5 or 10 minutes.
4. Enable Keep the last AutoRecovered version if I close without saving.
5. Store important workbooks in OneDrive or SharePoint and use AutoSave; otherwise, press Ctrl+S regularly.^4^

References

1. Recover your Microsoft 365 files | Microsoft Support
2. Recover an earlier version of an Office file | Microsoft Support
3. [Microsoft 365](https://support.microsoft.com/office/collab-files/save-back-up-and-recover-a-file-in-microsoft-office#back-up-and-recover-your-files)
4. Help protect your files in case of a crash | Microsoft Support