2018-4-16  Open Microsoft User Data, and then open Office 2011 AutoRecovery. On the Edit menu, click Select All. Drag all files into 'New Folder' on the desktop. The AutoRecovery folder should be empty. Open Excel for Mac 2011 and try to save a file. If you can save a. How to recover a document saved to Office 2011 AutoRecovery: Click Finder Go Hold down the Option key and choose Library Application Support Microsoft Office Office 2011 AutoRecovery. May this save you from a similar heart attack in the future. Microsoft Excel for Mac 2011 was crashing whenever I attempted to open it on a MacBook Pro laptop I use. Whenever I attempted to reopen it, I would be presented one by one with files to reopen that had been open when it crashed.

-->

Note

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Summary

Microsoft Excel now has a built-in AutoRecover feature that has replaced the AutoSave add-in that exists in versions of Excel that are earlier than Microsoft Excel 2002. The AutoRecover feature saves copies of all open Excel files at a user-definable fixed interval. The files can be recovered if Excel closes unexpectedly, for example, during a power failure.

This article contains an overview of the AutoRecover feature.

More Information

Auto Recovery Location Mac Microsoft Office 2011 Pc

How to configure the AutoRecover settings

Microsoft Office Excel 2007 and Excel 2010

The controls to configure the AutoRecover feature are in the Save settings in Excel Options.

For a longer list of the new features in Office 2019, see our.Office 2019 also includes new IT value for enhanced security and streamlined administration. Microsoft excel desktop for mac. And Focused Inbox moves less important emails out of the way—so you can get straight to taking care of business.

Note To open the Save settings, click the Microsoft Office Button in Excel 2007 or the File menu in Excel 2010, clickExcel Optionsin 2007 or Options in Excel 2010, and then click Save.

To configure the AutoRecover settings, follow these steps:

  1. Under Save Workbooks, click to select the Save AutoRecover info everycheck box to turn on the AutoRecover feature.

  2. In the minutes box, you can type any integer from 1 through 120. This box sets the number of minutes that will occur between saves.

    The default is 10 minutes.

  3. In the AutoRecover file location box, you can type the path and the folder name of the location in which you want the AutoRecover files to stay.

    The default location is as follows:

    drive:Documents and Settings*user_name*Application DataMicrosoftExcel

    Notes

    • If the location that you type is local (on your hard drive) or is on a network drive, and if this location does not exist, you receive the following error message:

      Cannot access directory path.

      To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:

      100100

    • If you click to clear the AutoRecover file location box but do not enter a new location, AutoRecover files will continue to be saved to the location that you cleared. This will occur until you type a new location.

      The AutoRecover file location box remains empty until you type a new location.

  4. You can turn off the AutoRecover feature in an individual workbook. To do this, click to select the Disable AutoRecover for this workbook only check box under the AutoRecover exceptions for box. Make sure that the workbook name is selected in the AutoRecover exceptions for box.

Microsoft Office Excel 2003 and earlier versions of Excel

The controls to configure the AutoRecover dialog box are on the Save tab of the Options dialog box.

Note To open the Options dialog box, click Options on the Tools menu.

To configure the AutoRecover dialog box, follow these steps:

  1. Under Settings, click to select the Save AutoRecover info everycheck box to turn on the AutoRecover feature.

  2. In the minutes box, you can type any integer from 1 through 120. This box sets the number of minutes that will occur between saves.

    The default is 10 minutes.

  3. In the AutoRecover file location box, you can type the path and the folder name of the location in which you want the AutoRecover files to stay.

    The default location is as follows:

    drive:Documents and Settings*user_name*Application DataMicrosoftExcel

    Notes

    • If the location that you type is local (on your hard drive) and if the location does not exist, you receive the following error message:

      Cannot access directory path.

    • If the location that you type is on a network drive, you will not receive an alert until your first AutoRecover attempt. You receive the following error message:

      Microsoft cannot save AutoRecover info to path. Please check the network connection or change the location on the Save tab of the Tools, Options dialog.

    • If you clear the AutoRecover file location box but do not enter a new location, AutoRecover files will continue to be saved to the location that you cleared. This occurs until you type a new location.

      The AutoRecover file location box remains empty until you type a new location.

  4. You can turn off the AutoRecover feature in an individual workbook. To do this, click to select the Disable AutoRecover check box under Workbook options.

When an AutoRecover event is triggered

When an Excel file is open and AutoRecover is turned on, AutoRecover does not save the file until the first change is made to the file, the AutoRecover save time interval passes, and Excel has been idle for some time (the default is 30 seconds). After AutoRecover saves the file, the file is only saved at subsequent save intervals if further changes are made.

When AutoRecover files are deleted

To keep from filling up your AutoRecover location with unneeded files, AutoRecover files are automatically deleted in the following situations:

  • When the file is manually saved.
  • The file is saved with a new file name using Save As.
  • You close the file.
  • You quit Excel, whether you choose to save the file or not.
  • You turn off AutoRecover for the current workbook.
  • You turn off AutoRecover by clearing the Save AutoRecover info every check box.

AutoRecover save timing

The AutoRecover 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.

Note

In Excel 2007, the minutes box is in the Save category in the Excel Option dialog box. In Excel 2010, 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 AutoRecover 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. 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:

322756 How to back up and restore the registry in Windows

  1. Quit Excel if it is running.

  2. Click Start, click Run, type regedit in the Open box, and then click OK.

  3. Locate and then select one of the following registry keys, as appropriate for the version of Excel that you are running.

    For Microsoft Excel 2002:

    HKEY_CURRENT_USERSoftwareMicrosoftOffice10.0ExcelOptions

    For Excel 2003:

    HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelOptions

    For Excel 2007:

    HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0ExcelOptions

    For Excel 2010:

    HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0ExcelOptions

  4. On the Edit menu, click New, and then click DWORD value.

  5. Type the following name for the new value:

    AutoRecoverDelay

  6. Press ENTER.

  7. Right-click the AutoRecoverDelay registry key, and then click Modify.

    Microsoft office for mac is a completely different version from the office for windows because it is a version which is totally based on the Microsoft Office productivity suite for mac os x. This Microsoft office for mac is one of the best and successors of 2011 and it is followed by the Microsoft office for mac of 2007. Price Currency: USD. Download microsoft office full version for mac free. 2020-3-31  Microsoft Office 2016 For Mac Free Download Full Version. Microsoft Office 2016 for Mac free download full version is a must-have productivity and business suite with its complete set of applications. It’s used by most company and education institution throughout the world. Microsoft Office 2016 For Mac Free Download Full Version in a single fast link. It is an offline installer of complete MS Office 2016 for Mac OS.

  8. In the Value data box, type a number between 1 and 600. This is the number of seconds before AutoRecover tries to save.

  9. When you are finished, click OK.

  10. Quit Registry Editor.

Note

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.

File formats that are saved by AutoRecover

AutoRecover saves all file formats that can be opened in Excel. To maintain speed and simplicity, AutoRecover 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 .xar (for example, ~ar18a.xar).

Autorecovery Location Mac Microsoft Office 2011 Download

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 its related .xar file name in the registry for the purpose of recovery.

AutoRecover and multiple instances of Excel

When more than one instance of Excel is running and one instance closes unexpectedly, a new instance of Excel is automatically started and the AutoRecover 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 AutoRecover files are opened. In the case of a power outage, all recovered files are opened when you start Excel again.

Compatibility

All AutoRecover settings, except the Disable AutoRecover workbook option, are stored in the system registry. AutoRecover settings are compatible with files from previous versions of Excel is not an issue.

When the Disable AutoRecover 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 AutoRecover workbook option is not affected.

References

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:

271513 How to troubleshoot errors when you save Excel files

If your power goes out or your computer malfunctions when working on an Word for Mac 2011 document, all you have to do is open the application again. Word 2011 for Mac looks for and opens any AutoRecover files for the document(s) that you were working on when an unexpected crash occurred. Your document opens with “Recovered” appended to the filename. Choose File→Save As from the menu bar to restore the original filename and location.

Word for Mac can recover files that were open because, by default, Word autosaves your document every ten minutes while you’re working on it. If you want, you can change the save time interval within the AutoRecover setting as follows:

  1. Choose Word→Preferences→Save from the menu bar.

    Word’s Save preferences are displayed.

  2. Change the number of minutes in the Save AutoRecover Info Every: [X] Minutes setting.

    The default is 10 minutes. Entering a lower number saves more often, but you may notice Word is more sluggish when it saves so often. Entering a higher number may make Word perform better, but you may lose more changes if a power outage or computer crash occurs.

    You can deselect this check box if you don’t want Word to save an AutoRecover file. You might do this for extremely large documents that take a long time to save. Of course, if you experience a power outage or computer crash, you will lose all your changes since the last time you manually saved the file.

    You don’t need to select the Always Create Backup Copy check box. With AutoRecover and Time Machine, the bases are covered. The option is there only for backward compatibility.

  3. Click OK when you’re finished.

Rarely, Word might not automatically display the AutoRecover file for the document(s) you were working on the next time you open Word. In that case, do the following in Word to open the AutoRecover file:

  1. Choose File→Open from the menu bar.

  2. Type AutoRecover or type a keyword or phrase in the Spotlight Search box in the top-right corner of the Open dialog.

  3. Double-click the most recently saved AutoRecover file, or select the file and click Open. If you did a keyword or phrase search, use the Last Opened information to help you choose a likely file to open.

    If the file you want is grayed-out, choose All Files in the Enable pop-up menu, which allows you to open any file type.

You can also use Mac OS X Time Machine to recover any file that you’ve saved at least once. When you use Word for Mac, it’s nearly impossible to lose more than a few minutes’ worth of work thanks to AutoRecover and Time Machine.