When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook:
If neither automatic nor manual repair works, there are some recovery methods that might help salvage your data. You can also take some preventive measures to avoid losing your work by automatically saving a backup copy of your workbook or creating a recovery file from time to time.
Choose one of the following methods to help recover your data. If it’s not successful, try another method. You can also try third-party software solutions to try to recover workbook.
With a backup copy of your workbook, you'll always have access to your data if your workbook is deleted accidentally or if it becomes corrupted.
A recovery file of your workbook also helps ensure you'll have access to your data if your workbook is deleted accidentally or if it becomes corrupted.