Skip to main content

Recover Unsaved Excel File


We normally avoid these settings but in the hour of need they save us rework time.

So if your working on a excel file and you forget to save it or click on don't save by mistake, follow below steps

 If the workbook was open for at least 10 minutes and created an AutoRecover version, Excel kept a copy for you.

Follow these steps to get it back:

  1. Open Excel.
  2. In the left panel, choose Open Other Workbooks.

  3. In the center panel, scroll all the way to the bottom of the recent files. At the very end, click Recover Unsaved Workbooks.

    A button for Recover Unsaved Workbooks is at the bottom of the File, Open panel of the File menu.

  4. Excel shows you all the unsaved workbooks that it has saved for you recently.

    A bunch of unsaved workbooks are shown in C:\Users\Bill\AppData\Local\Microsoft\Office\UnsavedFiles.
  5. Click a workbook and choose Open. If it is the wrong one, go back to File, Open and scroll to the bottom of the list.

  6. When you find the right file, click the Save As button to save the workbook. Unsaved workbooks are saved for four days before they are automatically deleted.

    The message bar says "RECOVERED UNSAVED FILE" and warns you that it is temporarily stored on your computer. A button offers to Save As.

Use AutoRecover Versions to Recover Files Previously Saved

Recover Unsaved Workbooks applies only to files that have never been saved. If your file has been saved, you can use AutoRecover versions to get the file back. If you close a previously saved workbook without saving recent changes, one single AutoRecover version is kept until your next editing session. To access it, reopen the workbook. Use File, Info, Versions to open the last AutoRecover version.

You can also use Windows Explorer to search for the last AutoRecover version. The Excel Options dialog box specifies an AutoRecover File Location. If your file was named Budget2020Data, look for a folder within the AutoRecover File folder that starts with Budget.

While you are editing a workbook, you can access up to the last five AutoRecover versions of a previously saved workbook. You can open them from the Versions section of the Info category. You may make changes to a workbook and want to reference what you previously had. Instead of trying to undo a bunch of revisions or using Save As to save as a new file, you can open an AutoRecover version. AutoRecover versions open in another window so you can reference, copy/paste, save the workbook as a separate file, etc.

Note

An AutoRecover version is created according to the AutoRecover interval AND only if there are changes. So if you leave a workbook open for two hours without making any changes, the last AutoSave version will contain the last revision.

Caution

Both the Save AutoRecover Information option and Keep The Last AutoRecovered Version option must be selected in File, Options, Save for this to work.

Tip

Create a folder called C:\AutoRecover\ and specify it as the AutoRecover File Location. It is much easier than trawling through the Users folder that is the default location.

This figure shows File, Options, Save where you can change the location for AutoRecover files.

Note

Under the Manage Version options on the Info tab you can select Delete All Unsaved Workbooks. This is an important option to know about if you work on public computers. Note that this option appears only if you’re working on a file that has not been saved previously. The easiest way to access it is to create a new workbook.

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

What if Analysis

Sometimes, you want to see many different results from various combinations of inputs. Provided that you have only two input cells to change, the Data Table feature will do a sensitivity analysis. Using the loan payment example, say that you want to calculate the price for a variety of principal balances and for a variety of terms. Make sure that the formula you want to model is in the top-left corner of a range. Put various values for one variable down the left column and various values for another variable across the top. From the Data tab, select What-If Analysis, Data Table.... You have values along the top row of the input table. You want Excel to plug those values into a certain input cell. Specify that input cell for Row Input Cell. You have values along the left column. You want those plugged into another input cell. Specify that cell for the Column Input Cell. When you click OK, Excel repeats the formula in the top-left column for all combinations of the top row and left colum...
Post a Comment
Read more

Import CSV In Power BI

  Import CSV file Click on Get Data à More à File option and select Text/CSV . Navigate to the CSV file which needs to be imported FL_insurance_sample.csv . Select the file and click on Open. FL_insurance_sampleDownload In the CSV window on top we have 3 dropdowns, preview of data and data load options.  Select Load and it will load to power query editor window. In the Power query editor the CSV file is loaded as a Queries . In power query editor we can edit, clean and transform the file as required. 3 Dropdowns and Data Load File Origin – Type of file origin. By default its 1252 Wester European (Windows). It’s the file type as per OS and region and country. Delimiter – Delimiter for column separation. By default it detects the delimiter from data , If the delimiter is not from the default options then we can select custom delimiter. Data Type Detection – By default it detects data types of columns based on top 200 rows, we can select entire data or do not detect data type ...
Post a Comment
Read more

Protect Formula Cells

The use of worksheet protection in Excel is a little strange. Using the steps below, you can quickly protect just the formula cells in your worksheet. It seems unusual, but all 16 billion cells on a worksheet start out with their Locked property set to True. You need to unlock all of the cells first: Select all cells by using the icon above and to the left of cell A1. Press  Ctrl+1  (that is the number 1) to open the Format Cells dialog. In the Format Cells dialog, go to the Protection tab. Uncheck Locked. Click OK. While all cells are still selected, select Home, Find & Select, Formulas. At this point, only the formula cells are selected. Press  Ctrl+1  again to display the Format Cells dialog. On the Protection tab, choose Locked to lock all of the formula cells. Locking cells does nothing until you protect the worksheet. On the Review tab, choose Protect Sheet. In the Protect Sheet dialog, choose if you want people to be able to select your formula cells or no...
Post a Comment
Read more