see autosaved files backup in Excel
Q8. In Excel, how can I access previously auto saved versions of my current Excel workbook?
For example, as I continue to make updates to my file and save the changes, I realize that the I have messed up the latest update and would like to revert to an earlier version if possible.
To do it in Excel, here is the answer:
To check if any previous versions of the active Excel workbook is available,
a) Click on "Info" option under "File" tab. The "Versions" section lists all the available old versions (if any) of the current Excel workbook.
Click on the name of the autosaved file to open it. Either you can replace the current version with the autosaved version or copy some information that was accidentally deleted or messed up with.