See autosaved files backup in Excel

For example, as I continue to make updates to my file and save the changes, I realize that the I have messed up the latest update and would like to revert to an earlier version if possible.

To do it in Excel, here is the answer:

To check if any previous versions of the active Excel workbook is available,

a) Click on "Info" option under "File" tab. The "Versions" section lists all the available old versions (if any) of the current Excel workbook.

Click on the name of the autosaved file to open it. Either you can replace the current version with the autosaved version or copy some information that was accidentally deleted or messed up with.

excel see autosaved files backup

 

You can find similar Excel Questions and Answer hereunder

1) How can I add Trendline to a chart using VBA?

2) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?

3) How can I ensure that important files always appear on the recent Excel workbooks list?

4) How can I get users to select a folder to save the output of my macro?

5) Here an explanation about spin button and how to control it using VBA

6) Vba list all files in a folder in Excel

7) How can I fill a series of data automatically?

8) How do i apply a formula to an entire column in Excel

9) How can I see where page breaks occur before actually printing?

10) How to hide and unhide rows and columns in excel VBA

 

Here the previous and next chapter