You should ensure that Excel’s Auto Recover feature is turned on. While Excel does have some ability to do this, it’s better to have it under your own control so you know at what point important changes were made. You never know when you will want to go back to a previous copy before you made changes. Because of this, it’s not a bad idea to make backup copies of your file before editing it. Modifying a large spreadsheet may also put you at risk of removing or changing things you don’t intend to. The more often you save, especially after big changes or additions, the less you have to worry. Getting into the habit of saving your work often is good practice. No one wants to go through the frustrating process of losing data and trying to recover it, so it’s best to try and prevent data loss in the first place.

Step 15: Your file should now be restored to the last auto-saved version. Step 3: Click on the “File” tab to go to the file menu section. Step 2: Open a new blank workbook (if it does not open one automatically).

We’ll also show you how to do that in the next section.įollow these steps to recover changes to your spreadsheet. It’s worth a try, though-recovering some data is better than recovering none at all.Īnother note on AutoRecover: that ten-minute save interval can be changed. Since it only saves a backup once every ten minutes, you may not get all of your work back. We’ll show you how to do that later in this article. It’s a healthy practice to verify if AutoRecover is enabled in your version of Excel. Second, AutoRecover is set only to save a backup every ten minutes (you can change this setting, however).

There are a couple of caveats, though: first, AutoRecover must be turned on-which, again, is normally done by default. How to Recover Unsaved Workbooks in ExcelĮxcel has an option to recover unsaved workbooks. Near the end of this article, we’ll take a quick look at some things you can do to avoid losing data.īut first, let’s see how to recover changes or edits you may have lost from your spreadsheet. The best way to keep your data safe is by preventing loss in the first place. This autosave/auto recover feature is usually enabled by default when the software is installed. It saves temporary copies of your file in a different location at regular intervals. If you lost it because of an unexpected shutdown or user error, though, there’s a chance you can get most or all of it back.Įxcel does have an autosave feature that runs in the background. So, if you delete data from Excel by accident, can you get it back?

How to Recover Unsaved Workbooks in Excel.

How to recover excel file not saved