CARA PERBAIKI FILE EXCEL YANG CORRUPT

Do you ever encounter a situation where you are working on an important Excel file, and suddenly, the file displays an error message that it’s corrupt? It can be frustrating and stressful, especially if you don’t have a backup of the file. But don’t worry, in this article, we will show you how to recover corrupted Excel files in Windows.

CARA PERBAIKI FILE EXCEL YANG CORRUPTCara Mengembalikan File Excel yang Corrupt di Windows

There are a few ways to recover corrupted Excel files, and we will go through them step-by-step.

1. Open and Repair

The first thing you should try is Excel’s built-in Open and Repair tool.

  1. Open Excel and go to File > Open.
  2. Select the corrupted file and click on the drop-down arrow next to the Open button.
  3. Choose Open and Repair from the options that appear.
  4. Follow the prompts and see if it repairs the file.

If this method works, then all you have to do is save the repaired file and continue where you left off.

2. Recover from Previous Versions

If the Open and Repair tool fails to recover your file, the next method you should try is to recover from previous versions.

  1. Right-click on the folder where the file is saved.
  2. Select Properties from the menu.
  3. Click on the Previous Versions tab.
  4. Select the version of the file you want to recover and click Restore.
  5. Copy the restored file to a new location and see if it opens without any errors.
Baca Juga :  CARA MENGGABUNG DUA FILE EXCEL UNTUK MENEMUKAN DATA YANG SAMA

If this method doesn’t work, don’t worry, we have a few more methods for you to try.

3. Use a Third-Party Recovery Tool

If the previous methods fail, you can use a third-party recovery tool. There are many recovery tools available online, but one of the best ones is EaseUS Data Recovery.

Here’s how you can use EaseUS Data Recovery to recover your corrupted Excel file:

  1. Download and install EaseUS Data Recovery on your computer.
  2. Launch the program and select the location where your corrupted Excel file is saved.
  3. Click Scan to begin the scanning process.
  4. Once the scan is complete, preview the files and select the corrupted Excel file.
  5. Click Recover, and the file will be restored to a new location on your computer.

EaseUS Data Recovery is a paid tool, but it offers a free trial, so you can try it out before purchasing.

Cara Memperbaiki File Excel yang CorruptGak Perlu Bikin Ulang! Ini Cara Memperbaiki File Excel yang Corrupt

Aside from the methods mentioned above, there are other techniques you can try to fix your corrupted Excel files.

1. Change File Extension

Changing the file extension can sometimes fix the issue with your corrupted Excel file. Here’s how you can do it:

  1. Right-click on the corrupted Excel file and select Rename.
  2. Change the file extension from .xlsx to .zip.
  3. Extract the contents of the zip file to a new folder.
  4. Navigate to the xl folder, then the worksheets folder.
  5. Delete the file with the .xml extension.
  6. Zip the remaining files in the worksheets folder back together.
  7. Change the file extension back to .xlsx.
  8. Try to open the file in Excel.
Baca Juga :  Cara Mengambil Bulan Dari Data Tanggal Di Excel

If this method works, then your file should open without any issues.

2. Use the Excel Repair Tool

Excel has its own built-in repair tool that you can use to fix corrupted Excel files. Here’s how you can use it:

  1. Open Excel and click on the File tab.
  2. Select Open from the left-hand menu.
  3. Click on the dropdown arrow next to Open and select Open and Repair.
  4. Select Repair.
  5. If the repair is successful, Excel will prompt you to save the file.

If the repair isn’t successful, you can also try the Extract Data option under Open and Repair. This will only extract the data from the Excel file and discard any formatting, formulas, and charts.

FAQ

1. Can I prevent my Excel file from becoming corrupted in the first place?

Yes, there are a few things you can do to prevent your Excel files from becoming corrupted:

  • Save your files frequently. This way, if your file does become corrupted, you can go back to a previous version.
  • Make sure your computer is running smoothly. Viruses and malware can corrupt files, so make sure you have antivirus software installed and keep it updated.
  • Avoid working with large files or complex formulas. These can cause Excel to crash, which can lead to file corruption.

2. Is it possible to recover data from a corrupted Excel file?

Yes, it is possible to recover data from a corrupted Excel file using data recovery software like EaseUS Data Recovery. However, it’s not guaranteed that you will be able to recover all of your data, and the recovered data may not be complete. That’s why it’s essential to save your files frequently and have a backup in case of file corruption.

Baca Juga :  CARA MEMBUAT SIKLUS AKUNTANSI DI EXCEL DENGAN MENGGUNAKAN RUMUS

Video Tutorial: How to Recover Corrupted Excel Files

For a more visual guide, check out this video tutorial on how to recover corrupted Excel files:

Now you know how to recover corrupted Excel files in Windows. Remember to save your files frequently, keep your computer running smoothly, and have a backup of your files in case of file corruption.