How to Enable Autosave in Microsoft Office Excel 2007?

How to Enable Autosave in Microsoft Office Excel 2007?

The autosave feature of Excel may not be known to all of the Excel users. It is one of the very important and awesome features of Microsoft Office Excel that should be used while you are doing data entry or data correction. While you are doing data entry or data correction in an excel file, you may lose all your entered data.

You may face this situation when you forgot to save the excel file after data entry and your PC got crashed suddenly due to some technical failure or your PC was not having power backup or your PC power went out or you needed to shut down your PC forcefully.

That may create lots of problems for you if you don’t have any hard copy of the data you entered. Imagine what will happen if you were entering very important and urgent data for your office and you accidentally closed the excel file or PC got restarted!  

Now, you can understand the importance Autosave feature of excel. So, while preparing any excel file with huge data, it is better to make sure that the Autosave feature of your Microsoft Office Excel 2007 is enabled. If it is not enabled then, you have to face the data loss problem.

Autosave feature protects your excel data entry by enabling the excel file to save its changes automatically in AutoRecover file location after every interval of minutes which you set in its settings.

So, how can you enable the autosave option in Microsoft Office Excel 2007? It is easy to enable the feature, just you need to follow the following steps that we have performed in case of Microsoft Office Excel 2007:

 Step 1 :                                                                                                                          

First, open any Microsoft Office Excel 2007 file.

 Step 2 :                                                                                                                         

Now, as shown in the above image click Microsoft Office 2007 Logo  to view the menu under Office Button.

You can notice one thing that when you place your mouse cursor on the above office logo, it displays the small window of Office Button.

 Step 3 :                                                                                                                         

After you click, it displays the Office Button menu as shown above.

Now, click Excel options button.

 Step 4 :                                                                                                                         

Select the Save tab from the left side panel of the Excel Options window.

 Step 5 :                                                                                                                         

Now, check the checkbox of Save AutoRecover information every field under the heading of Save workbooks, if it was not checked previously. In my case, it was already checked, so no need to check again.

 Step 6 :                                                                                                                         

Then, change the value 10 to 1 in minutes field to save your file automatically after every 1 minute.

You may change the AutoRecover file location path to store the backups as you wish. In my case, I kept it unchanged.

At last, click OK to apply the new settings related to the Autosave feature.

Please comment and share if you like this post on How to Enable Autosave in Microsoft Office Excel 2007?

Thank you.