Sets or returns the time interval for the AutoRecover object. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. After Auto-Recover saves the file, the file is only saved at subsequent save intervals if further changes are made. To keep from filling up your Auto-Recover location with unneeded files, Auto-Recover files are automatically deleted in the following situations:. The Auto-Recover timer checks for changed Excel files at the interval you set in the minutes box on the Save tab in the Options dialog box.
The timer starts when you start Excel. In Excel , the minutes box is in the Save category in the Excel Option dialog box. In Excel , the minutes box is in the Save category under File, Options.
When the first save interval passes, Excel checks to see whether any open files have been changed. If Excel locates changed files, an idle timer starts. The purpose of the idle timer is to make sure that the user does not make entries in the worksheet while the save operation occurs. The idle timer restarts each time that the user makes an entry into the worksheet so the Auto-Recover save file is not created until both the save interval passes and no entries are made for the duration of the idle time.
The default idle time is 30 seconds. To change the default idle time, use the AutoRecoverDelay registry key. To do this, follow these steps. Important This section, method, or task contains steps that tell you how to modify the registry.
However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it.
Then, you can restore the registry if a problem occurs. Your file is in an older format like. Your file is embedded inside another Office file. Your presentation is in slide show mode.
Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. To use it, follow the steps below:. Step 1: First, save the file to see the Save dialog box. If you have already saved the Excel sheet, go to the File and then to Save As. After that, choose a location. You will find some options. Now, when you save a spreadsheet, it will create a backup file with a.
Note: When you first time saves a spreadsheet, files will be the same. If you make editions in the original document and then again save it, the backup sheet will remain the same. However, the third time after saving the file, it will update the backup sheet with data up to the second save. So, the backup document is one version behind the current one. Therefore, if you make some changes and save your file, then wanted to go to the version without the changes, you can open the backup document.
You can see the saved spreadsheet in the exact location as the original one, and there is no way to change that. When you enable the backup and recovery features in Microsoft Excel, it will save you from losing some critical data or files. So, it would be best to use cloud storage, such as OneDrive. You can find autorecover excel files from there. It acts as an extra safety net whenever your computer crashes or catastrophically fails.
Moreover, you can quickly open and save the OneDrive documents from Excel.
0コメント