How to choose how often to backup in Microsoft Excel

  • Backing up Excel prevents loss of important data.
  • Excel saves AutoRecover information every 10 minutes by default.
  • The auto-recovery interval can be customized according to the user's needs.
  • Changing the auto-recovery time is a simple process in Excel options.

Microsoft Excel

If you regularly use the Microsoft Excel program, you probably already know that, as with Word and PowerPoint, it is essential to make regular backup copies of the spreadsheets that are edited. Thus, you can avoid a lot of scares in the event that for some reason there is some kind of failure when processing the save, being able to retrieve the information from the spreadsheets that you were editing.

In this case, by default in Excel copies are made in the form of self-recovery files every 10 minutes, but the truth is that depending on the editing speed you have as well as the importance of the spreadsheet you are editing it is possible which you prefer modify these times so that more or fewer backups are made.

So you can customize how often backup copies are made in Microsoft Excel

As we mentioned, in this case Microsoft allows the possibility of editing these times according to the tastes and preferences of the users of programs such as Excel. In this way, whether you want more copies to be made for prevention, or if you prefer that they be made more separated in time, you will only have to follow these steps:

  1. Open Microsoft Excel on your Windows computer, and then click on the "File" menu in the upper left.
  2. In the menu, you should choose "Options" at the bottom in the left sidebar to access all the Excel settings.
  3. Now, in the menu on the left choose the "Save" options.
  4. Look at the field of "Save AutoRecover information every" and, once you have made sure that the option is checked, modify every how many minutes you want the backups in question to be made.

Choose how often to backup in Microsoft Excel

Microsoft Excel
Related article:
How to display the current date in a cell in Microsoft Excel

After you have made the modification in question, you will only have click on the accept button and Microsoft Excel will automatically create an auto-recovery file In the minutes you have chosen, it allows you to return to the previous state of the spreadsheet without problems in case of loss of information on it.


Leave a Comment

Your email address will not be published. Required fields are marked with *

*

*

  1. Responsible for the data: Miguel Ángel Gatón
  2. Purpose of the data: Control SPAM, comment management.
  3. Legitimation: Your consent
  4. Communication of the data: The data will not be communicated to third parties except by legal obligation.
  5. Data storage: Database hosted by Occentus Networks (EU)
  6. Rights: At any time you can limit, recover and delete your information.