Recovering an Excel file after a crash can be a frustrating and stressful experience, but there are several steps you can take to try to recover your work. In this lesson you can learn how not to loose your workbook because of breakdown.

Have you ever wondered what happens if you have not saved file, and Excel would suddenly be turned off?

It’s important to keep in mind that the likelihood of successfully recovering an Excel file after a crash depends on the extent of the damage to the file and the recovery method used. However, by following these steps and trying different methods, you may be able to recover your work and minimize your loss.

Make sure AutoRecover is turned on

First, see where you can change Auto Recover settings. On the ribbon in Excel, click on the File and select Options. You get the following dialog box.

In the Save tab, you can see an option to set the Auto Recover frequency. The shorter the Auto Recover interval, the more recent the file will be that can be recovered. In other words, the longer the Auto Recover interval, the more work you could lose if Excel crashes.

Recover your file from AutoRecover

Now that Excel is closed, it is now the priority is to regain our work. In this situation at all costs to recover the file. Excel is closed. Open Excel again. On the left side of the window shows the information about the recovery of documents like the picture below.

There is a file name that you can recover. Click on the file and click Open.

The recovered file will open. Now, as soon as possible save (keyboard shortcut Ctrl + S) recovered document.

Hurrah! You managed to recover the lost document.

Recover your file from the Temp folder

The Temp folder is a temporary storage location for files that are created by your computer. The location of the Temp folder will vary depending on your operating system, but it is usually located in the C:\Users[username]\AppData\Local\Temp folder. Look for a file with a .tmp extension and try opening it in Excel.

Recover your file from the Recycle Bin

If you accidentally deleted your Excel file, you can check the Recycle Bin to see if it is still there. If it is, simply restore it to its original location and try opening it in Excel.

Here are some additional things to keep in mind when recovering Excel files:

• The sooner you start the recovery process, the better. The longer you wait, the more likely it is that the file will be damaged or overwritten.
• If you are using a third-party recovery tool, make sure to read the instructions carefully before using it. These tools can sometimes damage your files if they are not used correctly.
• If you are contacting Microsoft Support for help, be prepared to provide as much information about the lost or deleted file as possible. This includes the file name, the date it was created, and the last time it was saved.

Things to Remember

• Make sure AutoRecover is turned on.
• The shorter the Auto Recover interval, the more recent the file will be that can be recovered.
• If Excel crashes, open Excel again and look for the AutoRecover files on the left side of the window.
• If you can’t find the AutoRecover files, try searching the Temp folder for files with a .tmp extension.
• If you accidentally deleted your Excel file, check the Recycle Bin to see if it is still there.

See also  How to Use Filters in Excel to Find the Data You Need

Related posts:

Learn Charts in Excel for Beginners How to Print in Excel How to Concatenate Cells in Excel