{"id":3792,"date":"2022-02-20T10:00:35","date_gmt":"2022-02-20T04:30:35","guid":{"rendered":"https:\/\/www.systweak.com\/blogs\/?p=3792"},"modified":"2024-04-10T17:49:35","modified_gmt":"2024-04-10T12:19:35","slug":"how-to-recover-unsaved-excel-file","status":"publish","type":"post","link":"https:\/\/www.systweak.com\/blogs\/how-to-recover-unsaved-excel-file\/","title":{"rendered":"How to Recover Unsaved Excel File"},"content":{"rendered":"

Have you ever been working on an Excel sheet when your PC crashed? The first thing that comes to mind is \u201cWas the progress saved?\u201d or \u201cDid I press Ctrl+S to save the file?\u201d The stress is unreal, as an unexpected power cut or crash can flush all your hard work down the drain.<\/p>\n

Be it for a student or a professional, losing data due to unforeseen circumstances is a common occurrence.<\/p>\n

If you have also encountered a similar problem, worry no more\u2014this is the post that will save your data! Let us take a look at some of the ways to recover an unsaved Excel file.<\/p>\n

Read Here-<\/strong> How To Recover Lost Files After Upgrading Windows<\/a><\/p>\n

\n

To save your time, here are quick steps to recover unsaved Excel files<\/b><\/h4>\n

Tip:- Do not install the product on the same drive from which you have lost the data as it might overwrite it.\u00a0<\/span><\/p>\n

Step 1:\u00a0<\/strong> Download & Install Advanced Disk Recovery.<\/p>\n

\n

\"download\"<\/a><\/p>\n<\/div>\n

Step 2:<\/strong> Launch the recovery tool.
\nStep 3:<\/strong> Select the location from where you want to retrieve your deleted Excel files.<\/p>\n

\"Home
\nStep 4:<\/strong> Select the Driver you wish to scan > click \u2018Start Scan Now.\u2019
\nStep 5: Advanced<\/strong>\u00a0Disk Recovery will give you two scan modes to choose from: Quick Scan and Deep Scan. Select either, but we suggest using Deep Scan for thorough scanning.
\nStep 6:<\/strong> Review the scan result and select the Excel file to recover once the scanning is done.
\nStep 7:<\/strong> Choose the location where you want to save the file. Remember, it should not be the same location from which you are recovering data.<\/p>\n

You can return a permanently deleted Excel file using Advanced Disk Recovery.
\n<\/span><\/p>\n<\/div>\n\n

Check Here-<\/strong> How to Recover Deleted Audio files<\/a><\/p>\n

Best Ways to Recover Delete Excel Files – Windows<\/h2>\n

Method 1. Recovering Unsaved Excel Files From Windows PC<\/h3>\n

1.<\/strong> Launch Microsoft Excel.
\n2.<\/strong> Click File > Open > select Recent
\n3.<\/strong> At the bottom of the screen, you will find the Recover Unsaved Workbooks button:<\/p>\n

\"open
\n4.<\/strong> Hit the button to get the list of unsaved files.<\/p>\n

\"save<\/p>\n

Here, you will find the recent version of the file you forgot to save before Excel crashed.<\/p>\n

Configure the AutoRecover Settings in Excel<\/h3>\n

1.<\/strong> Launch Excel
\n2.<\/strong> Go to the File tab > click on Options<\/p>\n

\"excelhome\"
\n3.<\/strong> Click on the Save tab > Here, check the box next to \u2018Save AutoRecover information every <> minute\u2019 and ‘Keep the last autosaved version if I close without saving.\u2019<\/p>\n

Tip: Keep the auto recovery duration to a minimum. This ensures files get automatically saved, and you don\u2019t lose them.<\/p>\n

4.<\/strong> Click on OK.<\/p>\n

Must Read-<\/strong> How to Recover Deleted PSD Files<\/a><\/p>\n

Method 2. Restore Previous Versions From File History<\/h3>\n

If the above step yielded no results, you can recover your overwritten Excel documents using the File History option. Remember that the feature works only if it was previously enabled and when using Excel 2010 or 2013.<\/p>\n

This feature allows you to find and restore older versions of documents, Excel sheets, and other files.<\/p>\n

Note: This will only work if the File History in Windows is enabled. The feature allows you to find and restore older versions of a document, excel sheet, or other files.<\/p>\n

1.<\/strong>\u00a0 Press Windows + E to open File Explorer.
\n2.<\/strong> Right-click the unsaved Excel file > select Restore previous versions.<\/p>\n

\"file
\n3.<\/strong>\u00a0 A window will appear, and you\u2019ll see any previous versions you can restore.<\/p>\n

Additional Tip: Keep a backup of Excel files<\/h4>\n

Data backup always saves us from losing essential documents. To use this feature in Microsoft Excel 2010 and 2013:<\/span><\/p>\n

1. Launch Excel > go to the File tab > click \u2018Save as.\u2019
\n2. Next, click on the Browse tab at the bottom.
\n3. You will now get a Save as a window; at the bottom, you will find an option called Tools. From here, select \u2018General Options\u2019
\n4. Check on \u2018Always create a backup in the new Window.<\/p>\n

Every new Excel file you create will have a backup file. The backed-up Excel files have a .xlk extension.<\/p>\n

Method 3: Recover Overwritten Excel Files (For OneDrive Users)<\/h3>\n

If you are an active OneDrive user, you can recover the overwritten file even if your local file history is turned off. OneDrive saves a version of every file for such situations and can help you whenever required.<\/p>\n