Setting up AutoRecover in Excel 2011 for Mac

Apparently [easyazon-link asin=”0470903716″ locale=”us”] Office 2011 for Mac [/easyazon-link] is full of features.  Well, features only work if you enable them as I have found out in last few days when I had few issues with Excel running on Mac and lost some work. [easyazon-link asin=”1430233338″ locale=”us”] Microsoft Excel 2011 for Mac [/easyazon-link] has nice feature that you should enable so you can save your work and do not waste time again when crash of application for whatever reason happen on your Mac. This feature is called AUTORECOVERY and can be very easy enabled and setup in your Excel.

To set up AutoRecover, follow these steps:

  1. Choose Excel→Preferences from the menu bar.
  2. In the Sharing and Privacy section, select Save.
  3. Select the Save AutoRecover Information After This Number of Minutes check box.
  4. Enter the number of minutes that you want between AutoRecover file saves, or use the increase/decrease control.
  5. Click OK.

After you turn on AutoRecover, Excel saves your work at the specified interval so that you can recover in the event that the system or Excel crashes.


Recovery of your crashed document is very simple.

If your computer or Excel crashes, you can recover your work up to the most recent AutoRecover save, but only if you turned on AutoRecover saves. Take these steps to restore any workbooks that were open at the time of the crash:

  1. Click the Excel Dock icon.Excel presents any documents that you’re working on that have been saved at least once. Recovered documents have (Recovered) in the title bar.
  2. To keep the recovered version, choose File→Save As.The Save As dialog appears. Take one of the following actions:
    • To replace the existing file with the recovered version: Navigate to the file or use Spotlight to locate the existing file. Then, click the filename to change the recovered file’s name to the existing filename. Click Save to overwrite the existing file.
    • To save the recovered file without overwriting the original: Select a location to save the recovered file and enter a name for the file in the text box. Then click Save.

To discard a recovered workbook, click the red Close button to close the workbook. When prompted, don’t save changes.

[easyazon-image align=”none” asin=”1449393357″ locale=”us” height=”160″ src=”” width=”122″]

Leave a Reply