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. To view the AutoRecover settings, click on File and then Options.Ĭlick on Save in the left-hand menu and you’ll see the AutoRecover option under Save Workbooks.īy default, AutoRecover information is saved every 10 minutes. The Auto Recover feature is turned on by default and basically saves your document automatically into a temporary location after a set time interval.
0 kommentar(er)
