TipsMake
Newest

Time settings are automatically saved in Excel

During the process of working in Excel spreadsheets, you need to regularly save data for a short period of time to avoid the case of power failure or for some reason that you could not save it. In Excel, the default auto-save time is 10 minutes, but you can change the auto-save time to suit your needs.

Time settings are automatically saved in Excel Picture 1

The article shows how to change the time automatically saved in Excel.

With Excel 2010.

Step 1: Open Excel file and then select File -> Options .

Time settings are automatically saved in Excel Picture 2

Step 2: In Excel Options, select Save in the left menu.

Time settings are automatically saved in Excel Picture 3

Step 3: In the Save workbooks section , the default automatically save time is 10 minutes, you change the time automatically saved in the Save AutoRecover information every box (the unit is minutes). Then click OK .

Time settings are automatically saved in Excel Picture 4

For Excel 2007, instead of selecting File -> Options , select the Office Button icon -> Excel Options .

Time settings are automatically saved in Excel Picture 5

And perform the following steps similar to Excel 2010.

With Excel 2013 you perform the same operations as Microsoft Excel 2010 above.

Good luck!

Discover more
Samuel Daniel
Share by Samuel Daniel
Update 19 May 2020