

Let’s start with the bad news: The probability is high that your workbook is gone when you are reading these lines. But there are some steps you could try to recover it. It might be worth starting with the AutoRecover function and then – as long as unsuccessful – trying other steps.
Contents
Excel has a built in autosave function. By default, it saves a copy every ten minutes. You can also configure it to save the last version if you close Excel without saving. Recovering an autosaved version is easy: Find the folder and copy the version you’d like to recover.
Steps for recovering an Excel workbook.
Don’t just check for exactly the correct filename. Also look for files with a correct save date and time (but maybe no extension, in such case add “.xlsx” to the end) or .xslb files.
It might be worth a try to check for a binary file in your folder.
Did Excel crash during the saving process? If yes, you might want to check the folder, where your file is saved in. For saving, Excel creates a file without extension and then renames it and replaces the original file. If there is a file in your folder with no extension and created at the time, when you tried to save your workbook, do the following: Add an extension “.xlsx” to the filename and try to open it. There is a small chance, that your latest version could be restored.
Hold on a second. Was this information helpful so far?
Why don't you subscribe to our monthly, free Excel newsletter?
Subscribe now! Your welcome gift: Our big 45 pages keyboard shortcuts package. In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Of course, I'm also on other networks:
Twitter: Follow @professorexcel
Facebook:
Well, that’s it already for the more or less official ways to recover your data. But still, you could consider the following hints:
Excel too slow? Speed it up. Get the book now!
Tired of waiting for Excel? Use the 30 best methods described in this book to speed up Excel calculations!
Learn more or get it on Amazon!
There are many things you can do right now for preventing data loss.
Maybe now is the right moment to think about how to prevent data loss. There are some things you can do right now.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.