How to change Auto Recovery time in Microsoft Excel

Written by

Nikunj Patel

This article shows steps to change the default auto recovery in Micorsoft excel. It will be very useful to those who work on Microsoft Excel for their job, personal use, etc.

You are working on a very important file in Microsoft Excel. Suddenly your screen starts freezing, you read something appearing on the screen which says < Excel not responding > or < Excel stopped working>. And then that application is closed by the OS. Now when you open the file again..Boom, The changes you made in the file just 5 min back are lost. What you will do in this situation?

I know you are very smart. You will say, “Excel has the auto-recovery feature. I will go to auto-recovery and recover the file back. Huh… It’s so easy. And you are writing an article about it, go and learn something new,”

Wait there is a catch here, Let just say you recovered the file and when you open it still the changes made by you are not there. Why does this happen? It’s because the default autorecovery time is 10 min in Microsoft Excel. It means that every 10 min interval excel will save a copy of the file you are working on. We just have to change it to a time lesser than the default time. I suggest making it 1 min. Let’s see how we can do that.

Step 1: First ,Click on file button in an opened excel workbook

Step 2 : Then click on Option button

Step 3 : Click on Save tab and change the recovery time

1. Click on Save tab
2. Change autorecovery time to 1 min.
3. Click OK.

Voila..you have successfully changed the autosave time in your beloved Microsoft Excel. From next time you will never face problems mentioned earlier

You can also refer to this video for step by step instructions.

Keep Excelling…

If you know any subject that can be related to the manufacturing industry or industrial engineering, you can earn some income by becoming an article contributor to this website. For knowing more about it, please visit the Join us page.

You don’t need to have any experience in article writing, just knowledge of the subject is needed.

Also, you can know more about our team of article contributors by visiting the about us page.

Nikunj Patel @nikunjpatel

View Profile