12/26/2021»»Sunday

Recover Previous Version Of Excel Microsoft Excel For Mac

12/26/2021

If you’ve saved the file. Open the file you were working on. Go to File Info. Under Manage Workbook or Manage Presentation, select the file labeled (when I closed without saving). In the bar at the top of the file, select Restore to overwrite any previously saved versions. Tip: In Word, you can. Step 1: Scan entire hard drive to look for previous versions of excel files. Download and install Data Recovery on your computer and launch it. If your excel file was stored on an external drive, connect it to your PC too. First of all, head to the data type area and check the box on the 'Document' option.

Do you want to protect your workbooks from unexpected computer crashes or power failures? This article explains how to recover unsaved files and restore previous versions of your workbook in Excel 2016, 2013, and 2010. You'll also learn different ways of file backup on your PC or in the cloud.

Just imagine that you have been working on a very important document in Excel for some hours, creating a very complicated graph, and then… oops! Excel crashed, the power went out or you accidentally closed a file without saving. That is frustrating, but don't be so cut up about it - you can easily recover your unsaved document.

What is the worst that could be? While working on a workbook you found out that you made a mistake about an hour ago, you already made a lot of changes since that time and undo is not an option. If you want to know how to retrieve an overwritten Excel file, go ahead and read this article.

Excel AutoSave and AutoRecover

Excel provides us with such good features as AutoSave and AutoRecover. If they are enabled, it won't be a problem for you to recover unsaved files and restore previous versions in Excel 2016 - 2010. But these two features are often misunderstood, so at first let's define what they mean.

Excel AutoSave is a tool that automatically saves a new document that you've just created, but haven't saved yet. It helps you not to lose important data in case of a computer crash or power failure.

Excel AutoRecover helps you retrieve unsaved files after an accidental closure or crash. It allows you to restore to the last saved version which displays in the Document Recovery pane when you start Excel next time.

Note. The AutoRecover feature only works on Excel workbooks that have been saved at least once. If you never save a document before a computer crash, the Document Recovery pane won't show up in Excel.

Luckily, the options to auto save and auto recover files are turned on in Excel by default. If you are not sure, you can easily check them up.

How to configure the AutoSave (AutoRecover) settings in Excel:

  1. Go to the FILE tab and choose Options from the FILE menu
  2. Click Save on the left-hand pane of the Excel Options dialog.
  3. Make sure that both Save AutoRecover information every X minutes and Keep the last autosaved version if I close without saving are checked.
  4. Click OK.

    By default the AutoRecover feature is set to automatically save changes to your workbook every 10 minutes. You can shorten or lengthen this interval as you like. Here you can also change Excel AutoRecover file location and specify AutoRecover exceptions.

    Tip. If you want to be more secure in case of a crash or electricity failure, you should lower the time interval for saving information. The more frequently the document is saved, the more versions you have, the more chances to get all the changes back.

Now when Excel is configured to auto save and auto recover your documents, you will easily restore a file when something goes wrong. Further in this article you'll find out how to recover new files that you've just created and the ones that you've already saved.

How to recover unsaved Excel files

Suppose you are working on a new document in Excel and the program locks up unexpectedly. In a few seconds you realize that you didn't save the workbook. Don't panic and discover below how to recover an unsaved file.

  1. Go to FILE -> Open.
  2. Choose Recent Workbooks.
  3. Scroll down and click on the Recover Unsaved Workbooks button at the bottom of the list.
    Note. You can also go to FILE - > Info, open the Manage Workbooks drop-down and select Recover Unsaved Workbooks from the menu.
  4. When the Open dialog box pops up, just select the necessary file and click Open.

    The document will open in Excel and the program will prompt you to save it. Click on the Save As button in the yellow bar above your worksheet and save the file to the desired location.

Recover overwritten Excel files

Excel 2010 and 2013 make it possible not only to restore the unsaved workbooks, but also to recover previous versions of your document. It is especially helpful when you make a mistake that you can't undo, or when you want to see how the document looked like a few minutes earlier. See below how to retrieve an overwritten Excel file:

Click on the FILE tab and choose Info on the left-hand pane. Next to the Manage Versions button you'll see all autosaved versions of your document.

Excel automatically saves versions of the workbook at specified intervals, but only if you've made changes to your spreadsheet between these intervals. The name of each version has a date, time and the '(autosave)' note. When you click any of them, it will open along with the most current version of your workbook so that you can compare them and see all the changes.

If the program closed incorrectly, the last autosaved file is labeled with the words (when I closed without saving).

When you open this file in Excel, you'll get the message above your worksheet. Just click on the Restore button in the yellow bar to revert to the newer unsaved version of the workbook.

Note. Excel deletes all previously autosaved versions when you close the document. If you want to look at the previous version again, it is better to create a backup copy of your data.

How to save a backup copy of your workbook

Excel's Auto Backup is a very useful feature that can help you retrieve a previously saved version of your workbook. Saving a backup copy can protect your work if you accidentally save changes that you do not want to keep or delete the original file. As a result, you will have the current saved information in the original workbook and all previously saved information in the backup copy.

Though this feature is very helpful, it is hard enough to find in Excel 2010 - 2016. So let's do it together now:

  1. Go to FILE - > Save As.
  2. Select Computer and click on the Browse button.
  3. When the Save As dialog window pops up, click on the small arrow next to the Tools button at the bottom of the window.
  4. Select General Options… from the drop-down list.
  5. Check the Always create backup box in the General Options dialog and click OK.

Now you can rename your file and choose the desired location to save it. Excel will create a backup copy of the document in the same folder.

Note. A backed up copy is saved with different .xlk file extension. When you open it, Excel will ask you to verify that you really want to open this workbook. Just click Yes and you can restore a previous version of your spreadsheet.

Create time-stamped backup versions in Excel 2010 - 2016

Now you know how to enable the Excel Auto Backup option. However, every time you save a workbook, a new backup copy will replace the existing one. How can you get back to the earlier version if you've already saved the document several times? Take it easy - you have at least two ways out from this situation.

The first one is to use ASAP Utilities. They offer the Save file and create backup tool that helps you create multiple backup versions of your document. Once you install these utilities in Excel, you can use a special keyboard shortcut to save your workbook and automatically create a backup copy. Each version has a timestamp in the file name, so you can easily find the necessary copy according to the date and time it was created.

If you are comfortable with VBA, you can use a special Excel AutoSave macro to backup your files. Just copy it from this article and paste into the code Module. You can create as many backup copies as you want just by pressing a simple shortcut. It will restore a previously saved version of your workbook and won't overwrite any old backup file. Each copy is marked with a date and time of backup.

Back up Excel files to the cloud

For those who use cloud storage services for saving their docs, retrieving overwritten Excel files won't be a problem at all.

Let's have a closer look at OneDrive, Microsoft's storage option. Its biggest strength is that OneDrive is closely tied with Office. As an example, you can quickly open and save OneDrive documents right from your Excel. OneDrive and Excel work together to sync workbooks faster and let you work with other people on shared documents at the same time.

When you or your colleague makes changes to a document, OneDrive keeps track of the versions automatically, so you don't need to store multiple copies of the same document. With OneDrive's Version history you'll be able to see the earlier variants of the file, you'll know when the document was modified and who made the changes. You can also restore any of the previous versions if necessary.

Recover previous version of excel microsoft excel for mac windows 10

Another very popular cloud storage service is Dropbox. It keeps snapshots of every change in your Dropbox folder over the last 30 days. So even if you saved a bad change, or if the file has been damaged or deleted, you can restore the document to an older version with only a few clicks. Dropbox doesn't work so closely with Microsoft Office as OneDrive, but it is so simple that everybody can master it.

Now you know different ways to recover unsaved files and create a backup copy of your workbook in Excel 2010, 2013 and 2016. And I hope you won't push the panic button next time when your computer crashes or power goes out.

You may also be interested in:

-->

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

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.

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

Recover Previous Version Of Excel Microsoft Excel For Mac
  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.

  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

Recover Previous Version Of Excel Microsoft Excel For Mac Windows 10

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).

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.

Recover Previous Version Of Excel Microsoft Excel For Mac Free

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

Recover Previous Version Of Excel Microsoft Excel For Mac Download

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:

Recover Previous Version Of Excel Microsoft Excel For Mac free. download full Version

271513 How to troubleshoot errors when you save Excel files