Autosave In Excel For Mac

The following VBA code can help you to save the Excel file automatically after entering or updating data in a worksheet, please do as this: 1.Right-click the sheet tab that you want to autosave the workbook after entering new data, and then choose View Code from the context menu, in the opened Microsoft Visual Basic for Applications window, copy and paste the following code into the blank Module. How to Find Autorecover Files in Excel Mac (Complex) To understand and use the AutoRecover.

Are you the one dealing with the data loss situation due to closing unsaved Excel workbooks, or because of computer or Excel file crashing/freezing, power loss, or due to other unexpected reasons?

This is the worst nightmare faced by every Excel user. After working on a workbook for several hours you accidentally close it without saving or due to other spreadsheet hazards is a common problem. But the Good news is that there are few ways that help you to recover unsaved Excel file 2010/2013/2016/2019.

Well, you might not get the latest version with most recent changes, but it is a lot better than starting from the beginning as: Something is Better than Nothing”. So, it is worth to recover what you can. So, let’s have a look at the recovery methods to restore unsaved Excel files.

Automatic Solution: MS Excel Repair Tool

Try the professional recommended MS Excel Repair Toolto fix common Excel errors. This is the best tool to repair all sorts of issues, corruption, errors in Excel workbooks. This tool allows to easily restore all corrupt excel file including the charts, worksheet properties cell comments, and other important data.

It is a unique tool to repair multiple excel files at one repair cycle and recovers the entire data in a preferred location. It is easy to use and compatible with both Windows as well as Mac operating systems. This supports the entire Excel version.

Steps to Utilize MS Excel Repair Tool:

How To Recover Unsaved/Overwritten Excel File?

In this section, we will talk about the following points one by one.

1. Utilize the Excel AutoSave and AutoRecover Feature

Excel Autosave and AutoRecover are the two best features that help the user to recover unsaved Excel file data if they are enabled.

Excel AutoSave is a tool that automatically saves a new document that was created just now but hasn’t saved yet. This helps the user to recover important data that have been lost due to power failure or crash.

Excel AutoRecover allows the user to restore the unsaved files lost after an accidental closure and other unexpected reasons. With this, you can recover the last saved version displayed in the Document Recovery Pane, when the Excel file is started next time. This feature only works on Excel workbooks that have been saved at least once, otherwise, the Document Recovery pane won’t show up in Excel.

Moreover, these two features are amazing to recover unsaved Excel workbooks or restoreoverwritten Excel files. And this option by default comes ON in Excel file.

Steps to Organize The AutoSave (AutoRecover) Settings In Excel:

  • First, go to FILE tab > select Options from a FILE menu
  • Then click Save on the left-hand side of the Excel Options dialog box
  • Assure both “Save AutoRecover information every X minutes and Keep the last autosaved version if I close without savingare checked.
  • Click OK.

The AutoRecover feature is by default set to automatically save changes of your workbook in every 10 minutes. You can increase or decrease the time period as per your recommendation. You can also change the Excel AutoRecover file location and specify AutoRecover exceptions.

As the Excel is configured to AutoSave and AutoRecover your document you can easily restore unsaved Excel file when something went wrong.

Furthermore, in this article find out how to recover new files created just now or already saved.

2. Recover Unsaved Excel Files

If in a case while working on a new Excel file, the program locks up unexpectedly. And after a few seconds, you recognize you haven’t saved the workbook. Then, in this case, know how to recover unsaved Excel file.

  • Go to FILE
  • Select Recent Workbooks.
  • Now scroll down > click on Recover Unsaved Workbooks button.

Please Note:You can also, go to FILE > Info > open the Manage Workbooks drop-down > select Recover Unsaved Workbooks from the menu.

And when the Open dialogue box pops up, select the necessary file > click Open.

For

The document opens in Excel and 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.


3. Restore Overwritten Excel Files

In Excel 2010 and 2013 you are having an option to recover the previous versions of your documents. This is helpful if you have done any mistake and can’t undo, or your data gets overwritten.

Here know how to recover the overwritten Excel file:

  • Click on theFILEtab > select Info on the left-hand side.
  • Then, in the Manage Versions button, you’ll see all autosaved versions of your document.
For

Excel automatically saves workbook versions at specified intervals but if you have made changes to the spreadsheet between these intervals. Then the name of every version has a date and time and the “autosave” note.

And as you click on any of them, this will open with the most current version of your workbook, as you can compare them and identify the changes.

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

And as you open this Excel file, you will get the message above your worksheet. Click on the Restore button in the yellow bar to revert the latest unsaved version of the workbook.

Please Note: Excel deletes the entire earlier Autosaved versions at the time you close the document. If you want to look at the previous version, then it is better to create a backup of your data.

Note: The entire given screenshots are of Excel 2010, so if you are using any other Excel version then it might happen this not work in your case.

Bonus Tip To Avoid Excel Data Loss

#1: Save a Backup Copy of Your Workbook

The Auto Backup feature in Excel is very useful it allows the users to recover a previously saved version of the workbook. Making a backup of the important file is a very important and good habit to overcome the data loss situation.

This also protects the work if you accidental loss or in the situation you save changes that you do not want to keep or delete the original file. So, in this case, backup proved to be the best, as you have the current saved information in the original workbook and all previously saved information in the backup copy.

Well, this is a very helpful feature; but this is hard enough to find in Excel 2010 / 2013. So here follow the steps:

  • First, go to File> Save As.
  • And choose Computer> click on the Browse
  • As the Save As dialogue window pops up > click on the small arrow next to the Tools button
  • Now choose General Options from the drop-down list.
  • And check Always create a backup box in the General Options dialog > click OK.
  • Then rename your file > select the desired location to save it. Excel creates the backup copy of the document in the same folder.

Please Note: The backed copy is saved with different .xlk file extension, as you open it, Excel pop-up a message to verify that you really want to open this workbook. Click YES and you can restore a previous version of your spreadsheet.

Well, these are methods that help you to explore your knowledge on how to recover unsaved Excel file or how torecover overwritten Excel files. But if after following the process you are unable to recover unsaved Excel file then, in this case, make use of the automatic solution to restore entire data in the Excel workbook.

Turn On Autosave In Excel For Mac

Conclusion:

I hope the given methods will help you to recover unsaved Excel file mac or the overwritten Excel files. Well, the given methods to restore deleted/overwritten Excel files are not the best.

But they are quite involved and won’t get you the spreadsheet version you are hoping for but are quite effective to recover Excel file data.

Nevertheless, the best thing you need to do is overcome the situation if the often save data (autosaving is helpful) and also create a backup of the important files.


Excel

Margret

Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.

-->Out

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 Auto-Recover feature that has replaced the Auto-Save add-in that exists in versions of Excel that are earlier than Microsoft Excel 2002. The Auto-Recover 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 Auto-Recover feature.

More Information

How to configure the Auto-Recover settings

Microsoft Office Excel 2007 and Excel 2010

The controls to configure the Auto-Recover 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 Options in 2007 or Options in Excel 2010, and then click Save.

Autosave Office 365

To configure the Auto-Recover settings, follow these steps:

  1. Under Save Workbooks, click to select the **Save Auto-Recover info every check box to turn on the Auto-Recover 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 Auto-Recover file location box, you can type the path and the folder name of the location in which you want the Auto-Recover 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 Auto-Recover file location box but do not enter a new location, Auto-Recover files will continue to be saved to the location that you cleared. This will occur until you type a new location.

      The Auto-Recover file location box remains empty until you type a new location.

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

Microsoft Office Excel 2003 and earlier versions of Excel

The controls to configure the Auto-Recover 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 Auto-Recover dialog box, follow these steps:

  1. Under Settings, click to select the **Save Auto-Recover info every check box to turn on the Auto-Recover 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 Auto-Recover file location box, you can type the path and the folder name of the location in which you want the Auto-Recover 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 Auto-Recover attempt. You receive the following error message:

      Microsoft cannot save Auto-Recover 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 Auto-Recover file location box but do not enter a new location, Auto-Recover files will continue to be saved to the location that you cleared. This occurs until you type a new location.

      The Auto-Recover file location box remains empty until you type a new location.

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

When an Auto-Recover event is triggered

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

When Auto-Recover files are deleted

To keep from filling up your Auto-Recover location with unneeded files, Auto-Recover 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 Auto-Recover for the current workbook.
  • You turn off Auto-Recover by clearing the Save Auto-Recover info every check box.

Auto-Recover save timing

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.

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

  8. In the Value data box, type a number between 1 and 600. This is the number of seconds before Auto-Recover 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 Auto-Recover

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

Auto-Recover 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 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.

Compatibility

Autosave In Excel For Mac Os

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.

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