HomeApplicationOffice informationTime settings are automatically saved in Excel

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!

4.5 ★ | 2 Vote

You should read it

May be interested

  • How to remove all Hyperlink links in WordPhoto of How to remove all Hyperlink links in Word
    how to remove all hyperlinks in word - if you remove hyperlinks one by one, it will take a lot of time, instead of removing all hyperlinks in word documents with the following ways.
  • Create PowerPoint slideshows from Word documentsPhoto of Create PowerPoint slideshows from Word documents
    create a powerpoint slide show from word documents - with just a few simple steps, you have created a powerpoint slide show from existing word documents without spending time to retype the content.
  • How to print multiple Word pages in one sheet of paperPhoto of How to print multiple Word pages in one sheet of paper
    by default, when printing, you print a page of word documents on a sheet of paper. but for the needs and purposes of many people, to save or fit the purpose of using the prints, you want to print many pages of word in a single sheet of paper.
  • Instructions for formatting data in ExcelPhoto of Instructions for formatting data in Excel
    excel spreadsheets support a variety of data types for cells in the worksheet: numeric, percentage, date, time, fraction, etc., with different data, you should format the data type correctly. for that data box. so when calculating or processing data
  • Add, create comments in ExcelPhoto of Add, create comments in Excel
    add and create comments in excel - in excel worksheet, support you to add comments for data cells, you can add comments to explain more about data cells so that when you forget you can choose back to the data box to see.
  • Extract Excel content into image formatPhoto of Extract Excel content into image format
    there is a lot of data on excel spreadsheets you want to turn into images for use in word documents or for sharing with everyone. instead of taking pictures of data on excel spreadsheets and editing to get images that contain data content, you can t

Office information