If you have any questions, feel free to comment.Microsoft Excel is one of the staple productivity applications that you should have on your computer along with Word, PowerPoint, and Outlook. It’s always a good option to use cloud storage (like OneDrive) as an extra safety net in case your computer catastrophically fails. This feature doesn’t add a whole lot of safety to your document, but it’s good in certain circumstances.Įnabling these backup and recovery features in Excel will hopefully save you from losing important data. The file is saved in the same location as the original file and there doesn’t seem to be a way to change that. So if you made a bunch of changes, saved your file and then wanted to go back to the version that didn’t have those changes, you could just open the backup file.
The third time you save it, however, the backup file will be updated with information up to the second save.īasically, the backup file is always one version behind the current version. If you make edits to the original file and then save it again, the backup file will still remain the same (the original data). Note that the first time you do this, the files will be exactly the same.
Click OK and now when you save the file, an Excel backup file will also be created with a. Go ahead and check the Always create backup box. When you click on that, a small window will appear with some more options. You’ll see a couple of options, one of which is General Options. In the dialog, click on the Tools button that is to the left of the Save button. When you do this, it’ll bring up the Save As dialog. If you already have a saved Excel document, go to File and then Save As and choose a location. To use it, you have to first go and save your file to get to the Save dialog box. AutoBackupĪnother feature that not many people really know about it is AutoBackup. If you are a heavy Excel user, I would suggest setting the AutoRecover interval to something like 2 or 3 minutes instead of 10. Just keep that in mind when using this feature. In addition, if you manually quit Excel and choose not to save the data, it will delete the AutoRecover data. So basically, whenever you save the file, it gets rid of the AutoRecover data. You turn off AutoRecover completely or for just the workbook.You close the file or quit Excel (whether you save the file or not).You save the file manually or by using File – Save As.Note that AutoRecover information is also deleted automatically by Excel in the following circumstances: You can change the location in the settings above to a separate hard drive or even to a network location, which I highly recommend. The major downside to this feature is that the AutoRecover data is stored on the same hard drive as your file, so if something happens to your hard drive, everything will be gone. Overall, this is a really useful feature for those times when you didn’t save all your work, but Excel ends unexpectedly. In my case, it had the original file, which had data in just A1 and A2, and it also had the AutoRecovered file, which included the data that I had not saved to disk.Ĭlicking on any of the items in the list will open another instance of Excel showing the data in that particular file. If you click on that, it will bring up a list of Excel files that can be recovered. After that, I reopened Excel and immediately saw an option called Show Recovered Files. In my case, I simulated an Excel crash by opening the task manager and killing the Excel process. Since the AutoRecover interval is set for 10 minutes, you need to wait at least that long for the data to be saved. Now let’s say I add the following data to the Excel spreadsheet and wait about 10 minutes without saving my document. So how does it work? Basically, let’s say you have a worksheet like the one below and you have it saved. Also, the autosaved information is saved in the AutoRecover file location listed here. In addition to the interval, Excel has to be idle for 30 seconds before the data will be saved. By default, AutoRecover information is saved every 10 minutes.
0 kommentar(er)
