CARA MENGEMBALIKAN FILE EXCEL 2013 YANG BELUM TERSAVE

Are you worried about losing important Excel files that haven’t been saved yet? Don’t worry! There are ways to recover unsaved Excel files. In this article, we’ll go through step-by-step instructions on how to recover unsaved Excel files, how to recover lost formulas, and how to recover Excel files from a flash drive.

How to Recover Unsaved Excel Files

Have you ever worked on an Excel file for hours only to accidentally close it without saving? Don’t panic! There’s a way to recover your unsaved Excel file.

There are two ways to recover unsaved Excel files: from the temporary file folder or from the AutoRecover feature in Excel.

Method 1: Recovering from the Temporary File Folder

When you’re working on an Excel file and click “Save,” Excel automatically saves the changes to a temporary file folder. If Excel crashes or you accidentally close Excel without saving, you can try to recover the unsaved Excel file from this temporary file folder.

Here are the steps to recover unsaved Excel files from the temporary file folder:

1. Open Excel and click on “File.”
2. Click on “Info.”
3. Click on “Manage Workbook” and select “Recover Unsaved Workbooks.”
4. Find the unsaved file you want to retrieve and click “Open.”

If this method didn’t work, you can try the second method: recovering from the AutoRecover feature in Excel.

Method 2: Recovering from the AutoRecover Feature in Excel

Excel has a built-in feature called AutoRecover, which saves changes to your Excel file every few minutes. If Excel crashes or you accidentally close Excel without saving, you can try to recover the unsaved Excel file from the AutoRecover feature in Excel.

Here are the steps to recover unsaved Excel files from the AutoRecover feature:

1. Open Excel and click on “File.”
2. Click on “Info.”
3. Click on “Manage Workbook” and select “Recover Unsaved Workbooks.”
4. Select “AutoRecover” and find the unsaved file you want to retrieve.
5. Click “Open.”

How to Recover Lost Formulas in Excel

Have you ever lost a formula in Excel? Maybe you deleted a cell that contained the formula, or maybe your Excel file crashed before you had a chance to save the formula. Don’t worry, there’s a way to recover lost formulas in Excel.

Here are the steps to recover lost formulas in Excel:

1. Open the Excel file that contains the lost formula.
2. Click on “File” and select “Options.”
3. Select “Advanced.”
4. Scroll down to the “Display” section and check the box next to “Show formulas in cells instead of their calculated results.”
5. Click “OK.”
6. You should now be able to see the lost formula in the cell where it was originally located.

How to Recover Excel Files from a Flash Drive

Have you ever saved an Excel file to a flash drive and lost it? Don’t panic! There’s a way to recover your lost Excel file.

Here are the steps to recover Excel files from a flash drive:

1. Connect the flash drive to your computer.
2. Open File Explorer and click on the flash drive.
3. Search for the Excel file you want to recover.
4. If you find the file, simply copy and paste it back onto your computer.
5. If you can’t find the file, try using a data recovery program like Recuva or EaseUS. These programs can scan your flash drive for deleted files and recover them.

FAQ

1. Can I recover an Excel file that was deleted?

Yes, you can recover an Excel file that was deleted. If you didn’t delete the file from the Recycle Bin, you can simply restore it from there. If you did delete the file from the Recycle Bin, you can try using a data recovery program like Recuva or EaseUS to recover it.

2. Is it possible to recover an Excel file that was overwritten?

It’s very difficult to recover an Excel file that has been overwritten. When you save a new version of an Excel file, it replaces the old version, and the old version is usually irretrievable. However, if you have a backup of the old version of the file, you can try to recover it from the backup.

Conclusion

Losing an important Excel file can be stressful, but don’t worry. With the steps outlined in this article, you should be able to recover unsaved Excel files, lost formulas, and Excel files from a flash drive. If all else fails, a data recovery program can help you recover deleted or overwritten Excel files. Remember to save your Excel files often to avoid the stress of losing important data.