Increase AutoRecover Frequency in Excel 2010

Many people that have been using Excel for a significant period of time are likely to have an unpleasant memory where their computer crashed, or Excel crashed, and they lost a lot of unsaved work.

Excel has an AutoRecover feature that is meant to help combat this problem, but, unfortunately, it is only set to automatically recover information every ten minutes.

You can make a lot of changes to a spreadsheet in that amount of time, so you may be wondering how to increase the AutoRecover frequency in Excel 2010.

Luckily this is a configurable option within the program, and you can make the adjustment in just a few short steps.

AutoRecover Excel 2010 More Frequently

There are so many different situations where AutoRecover can be a real lifesaver that it is hard to pin down just a few.

But it is a very helpful feature that you can modify to be even more helpful. By having AutoRecover run more frequently, you can ensure that only a small amount of work is lost in the event of a power failure or program crash. Continue reading below to learn how to increase the AutoRecover frequency in Excel 2010.

Step 1: Launch Microsoft Excel 2010.

Step 2: Click the File tab at the top-left corner of the window.

Step 3: Click Options at the bottom of the column on the left side of the window.

excel 2010 options menu

Step 4: Click the Save option in the column at the left side of the Excel Options window.

save tab of excel options window

Step 5: Click inside the field to the right of Save AutoRecover information every, then type the number of minutes after which you want the feature to automatically run. Note that the most frequent interval you can use is 1 minute.

increase autorecover frequency in excel 2010

Step 6: Click the OK button at the bottom of the window to save your changes.

Now that you know how to increase the autorecover frequency in Excel 2010, you can make sure that your computer is saving your workbook files on a more frequent basis.

While using AutoRecover frequently should not be problematic on newer computers and smaller spreadsheets, it can noticeably slow down Excel if you are using an older computer or are working with a very large spreadsheet.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Leave a Comment