recover not saved files in Excel

Q9. Is there a way I can recover unsaved work?

For example, I created an Excel workbook with contents and accidentally closed it without saving - is there a way I can recover that work?

To do it in Excel, here is the answer:

To recover an Excel workbook that was closed without saving,

a) Click on "Info" option under "File" tab. Click on "Manage Versions".

excel recover not saved files

b) When you click on "Recover Unsaved Workbooks", a list of all draft versions of workbooks is displayed. Choose the file that you are interested in and if lucky, you can recover something that you need.

The files are read-only in xlb file format. To save the file, new name needs to be provided. Draft versions are deleted after 4 days or when the file is edited.

excel excel recover not saved files

c) Excel tiles the selected image across the worksheet as shown in Screenshot below.


You can find similar Excel Questions and Answer hereunder

1) I frequently use a Macro - is there a way to quickly access the Macro using a Keyboard Shortcut?

2) How can I extract file name from a full path?

3) How can I get an estimate of Standard Deviation of a sample dataset?

4) How do I add a shape using VBA?

5) Write to text file without quotes in vba in Excel

6) How do I have proper (Capitalize the first letter in each word of a text) text in cells ?

7) How can I find number of months that has elapsed given 2 dates?

8) Is it possible to use 2 labels in X-Axis of a chart (like both Month and Date, Date and Day, Date and Shift)?

9) How can I avoid updates to cell values during macro execution?

10) Is there a way to create an visually impactful report with stop lights indicating automatically if Target is met?

11) Line break in vba message box in Excel

12) Import txt file in Excel

13) How can I change the meta-data of file (Author, Company Name and the like)?

14) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?

15) How to disable ability to insert Rows and Columns in Excel (using VBA)?