CARA MEMBUKA FILE EXCEL YANG TIDAK TERSIMPAN

Have you ever experienced accidentally closing an important Excel file without saving it? Or have you ever encountered an issue where your Excel file crashed before you could save it? Losing unsaved data can be frustrating, especially when it contains crucial information that can affect your work or business. In this article, we will discuss different ways to recover unsaved Excel files.

Method 1: Recover Unsaved Excel Files Using Microsoft Excel

If you have Microsoft Excel, you can take advantage of its built-in recovery feature. This can help you retrieve unsaved or lost Excel files. Follow these steps:

  1. Open a new Excel file.
  2. Select the File tab and click on Info.
  3. Click on Manage Workbook and select Recover Unsaved Workbooks.
  4. Select the file that you want to recover and click Open.
  5. Once you have opened the file, save it immediately to prevent losing it again.

Note that this method may not work if the AutoRecover feature is disabled in your Excel settings. To enable this feature, follow these steps:

  1. Open Excel and click on the File tab.
  2. Click on Options.
  3. Select Save from the left-hand sidebar.
  4. Under Save workbooks, make sure the checkbox for Save AutoRecover information every X minutes is selected and that the duration is set to your desired time interval.
  5. Click OK to save your changes.
Baca Juga :  Cara Membuat Rata Rata Tertimbang Di Excel

Method 2: Recover Unsaved Excel Files Using Third-Party Software

If the built-in recovery feature of Excel did not work or if you do not have Microsoft Excel, there are third-party software programs available that can help you recover unsaved Excel files. One example is Recuva, a free data recovery software that can retrieve lost or deleted files from your computer. Follow these steps to use Recuva:

  1. Download and install Recuva from their official website.
  2. Launch the program, and in the wizard, select the file type you want to recover (in this case, .xls or .xlsx).
  3. Choose the location where the file was saved before it was lost.
  4. Click on the Scan button.
  5. Once the program has finished scanning, select the file you want to recover and click on Recover.
  6. Save the recovered file to prevent losing it again.

Note that there are other data recovery software programs available aside from Recuva. Do your research and read reviews to determine which software would best suit your needs.

FAQ

Q: Can I recover unsaved Excel files on Mac?

A: Yes, you can recover unsaved Excel files on Mac using the AutoRecover and AutoSave features in Microsoft Excel. If these features are turned off, you can also use third-party data recovery software programs for Mac such as EaseUS Data Recovery Wizard and Disk Drill.

Q: Can I recover an overwritten Excel file?

A: Yes, you can recover an overwritten Excel file by utilizing the Windows Previous Versions feature. This allows you to access previous versions of a file and restore it if necessary. To use this feature, right-click on the file and select Properties. Click on the Previous Versions tab and select the version you want to restore.

Baca Juga :  CARA MEMBUAT APLIKASI AKUNTANSI DENGAN EXCEL 2007

Video Tutorial

For a video tutorial on how to recover unsaved Excel files using Microsoft Excel, check out this helpful video:

Conclusion

Losing unsaved Excel files can be a frustrating experience, but there are ways to retrieve them. By using the built-in recovery feature of Microsoft Excel or third-party software programs, you can recover lost or deleted Excel files. Remember to always save your files to prevent losing them again in the future.