Can you autosave in excel 2007

For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:. Locate and then select one of the following registry keys, as appropriate for the version of Excel that you are running.

In the Value data box, type a number between 1 and This is the number of seconds before Auto-Recover tries to save. Only manually performed actions in the program affect the idle timer. Formulas that automatically update the file do not affect the idle timer. Excel saves the file when the idle time is reached, between the automatic updates to the formulas.

Auto-Recover saves all file formats that can be opened in Excel. To maintain speed and simplicity, Auto-Recover saves all files as the current Excel file format, regardless of the original file format opened.

The file is saved as a hidden file with an arbitrary filename with the extension ". When you try to save a recovered file upon reopening Excel after it closed unexpectedly, the original file format and name is suggested as the Save file type. Excel stores the original file name and it's related ". When more than one instance of Excel is running and one instance closes unexpectedly, a new instance of Excel is automatically started and the Auto-Recover files are opened. If all instances of Excel close unexpectedly, but the computer is still running, a single instance of Excel is started and all Auto-Recover files are opened.

In the case of a power outage, all recovered files are opened when you start Excel again. All Auto-Recover settings, except the Disable Auto-Recover workbook option, are stored in the system registry. Auto-Recover settings are compatible with files from previous versions of Excel is not an issue. When the Disable Auto-Recover workbook option is set, and the file is opened in an earlier version of Excel, saved, and then reopened in a later version of Excel, the Disable Auto-Recover workbook option is not affected.

For more information about how to troubleshoot errors when you save Excel files, click the following article number to view the article in the Microsoft Knowledge Base:.

Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Click on OK. The proper AutoSave add-in is now installed.

This displays the AutoSave dialog box. See Figure 2. Figure 2. The AutoSave dialog box. Use the controls in the dialog box to indicate how you want the saving to occur. Excel displays the Options dialog box. Make sure the Save tab is selected. See Figure 3. Figure 3. The Save tab of the Options dialog box. Use the controls on the tab to indicate how you want the saving to occur. Author Bio. Lines that Don't Change When You Type Create a form in Word and you will invariably be faced with the need to places fill-in-the-blank lines in the document.

Discover More. Identifying the Last Cell Changed in a Worksheet When someone changes a cell in a worksheet, Excel normally goes along its merry way of keeping everything up to date.

Changing the User Interface Language Tired of Windows showing you information in English when you'd much prefer a different language? More ExcelTips menu. Changing an Invalid Autosave Folder Excel allows you to specify where it stores various files used by the program. Hide my email address. What is three more than 0? This will save your work on OneDrive and SharePoint accounts in real-time, preserving a backup if you lose your laptop.

Only enable this for password-protected files. Never share sensitive information such as Social Security numbers or financial data via a OneDrive or SharePoint file.

Select Save AutoRecover information and choose the interval at which you'd like to save it. The default is 10 minutes, but you can set it lower or higher, depending on your preferences. Select Keep the last AutoRecovered version if I close without saving to preserve your work if you lose power or accidentally close Excel.

Make a note of where Excel will save these files. If you prefer a more accessible location, you can write it out here. You may be unable to see your AutoRecover location in File Explorer, depending on whether or not you're logged in as an administrator and what your settings are for data recovery. You also may be unable to change the file path if you're not an administrator. If you don't have an AutoSave option in your version of Excel or don't want to use OneDrive or SharePoint to back up your files, you can also use third-party software like Google Drive or Dropbox to back up your data regularly.

Before using these services, think carefully about potential security and space. If you're backing up confidential information, there's an inherent risk of a breach. If you're looking to save documents for work, consult your workplace's IT department, if available, for solutions they've vetted.

Additionally, any backup service will have a limited amount of space, and you'll probably want to use it to backup other files as well.

More room is available, but you'll have to subscribe to it. Look at your needs carefully before signing on to any backup service. Actively scan device characteristics for identification. Use precise geolocation data. Select personalised content. Create a personalised content profile.

Measure ad performance. Select basic ads.