Lesson 29: How to use AutoRecover in Excel

Excel periodically saves a copy of the Excel file. So, in this article, we will learn how to recover files that have never been saved and how to recover files that have been saved at least once.

Join the channel Telegram belong to AnonyViet 👉 Link 👈

If Excel crashes, it will display the Document Recovery Pane when you reopen Excel. Here is a quick way to restore the last autosave file.

Lesson 29: How to use AutoRecover in Excel 12

How to use AutoRecover in Excel

The file was never saved

If you’ve never saved a file and you accidentally clicked Don’t Save below when you closed Excel (or Excel crashes), take the following steps to restore the last autosaved file.

Lesson 29: How to use AutoRecover in Excel 13

Note: Excel will tell you if a recent copy is still available.

First, click on the File tab and select Info.

Next, select Manage Workbook -> Recover Unsaved Workbooks.

Lesson 29: How to use AutoRecover in Excel 14

Click the last auto-archived file.

Saved at least once

If you’ve never saved a file and you accidentally clicked Don’t Save below when you closed Excel (or Excel crashes), take the following steps to restore the last autosaved file.

Lesson 29: How to use AutoRecover in Excel 15

Note: Excel will tell you if a recent copy of the file is still available.

First, open the Excel file.

Go to the File tab, click Info.

In Manage Workbook, click on the last autosaved file.

Lesson 29: How to use AutoRecover in Excel 16

Version of the file

When you are working on Excel, Excel saves all the files that were automatically saved in the Manage Workbook.

See more:  How to delete redundant last page in Word

On the File tab, select Info.

At any time, you can revert to a previous version of the Excel file.

Lesson 29: How to use AutoRecover in Excel 17

Note: Excel will delete all previously autosaved files when you close the Excel file.

Other options

To change options in AutoRecoverperform the following steps.

On the File tab, click Options -> Save.

Lesson 29: How to use AutoRecover in Excel 18

Note: you can set to save AutoRecover information every x minutes, or change the location of the AutoRecover file, etc.

In addition, you can also see many other excel articles here.

The article won: 1/5 – (999 votes)

Source: Lesson 29: How to use AutoRecover in Excel
– TechtipsnReview

, ,

Leave a Reply

Your email address will not be published. Required fields are marked *