see autosaved files backup in Excel

Q8. In Excel, how can I access previously auto saved versions of my current Excel workbook?

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) I have a very complex macro that runs for a long time - is there any way I can set up an audible alarm indicating macro run is over?

2) How can I create dependent drop down lists?

3) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

4) How can I set up a dynamic named range that expands automatically when new items are added to the list?

5) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?

6) Is there a way to get a log value of a number using Excel?

7) Formula does not calculate in Excel

8) I want a formula to concatenate multiple cell values separated by a line break.

9) How can I remove hyperlinks from a range of cells?

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

11) Is there any way I can see more region of my WorkSheet?

12) How can I add and link a Chart Title to a cell value?

13) How can I loop through all WorkSheets and get their names using VBA?

14) How can I avoid a gap in a line chart for missing data?

15) How can I prevent users from seeing / accessing my macro code?