You’re down to the wire on a large Excel project, you’re keying in your last few cells of data, and Excel decides to freeze. Suddenly, the program crashes, erasing all of your hard work. Or did it? If you’ve ever been in this situation, you know how terrifying it can be when Excel quits in the middle of a project.
Fortunately, there are a few ways to open recently closed Excel files, whether you decided to close the file or if Excel decided to close it for you. Let’s take a look at some ways to open recently closed files.
Excel’s AutoRecover feature is a great way to protect your work in the event that Excel crashes. This feature allows you to restore an unsaved file if you accidentally close the file or if Excel crashes. It’s important note that you need to have saved the file at least once for it to be AutoRecovered in the event of an accidental file closure.
To turn on AutoRecover, go to File, then select Options in the menu. From there, select Save from the list of Options and make sure that Save AutoRecover Information is selected. You can set the frequency that the program automatically saves. You can also select keep the last autosaved version if I close without saving to protect the latest version of the file.
When you open Excel again, you’ll see a Document Recover pane on the left side of the worksheet, allowing you to open the most recently saved version of the file. No more lost data!
Open Recently Closed Files
If you are looking for a simple way to access recently closed files and you haven’t accidentally closed the file, all you need to do is open a blank workbook in Excel, then go to File > Open. You will see an option that says Recent Workbooks, allowing you to select an open a recent file you worked on.
If you haven’t saved the file, at the bottom of the Recent Workbooks list there is an option to select Recover Unsaved Workbooks. This is another way to recover files that crashed unexpectedly, and allows you to recover the data even if you never saved the workbook.
The next time you close out of a file, or the file crashes unexpectedly, don’t panic. These two simple methods will allow you to recover your data and get back on track in no time.