CARA MENGATASI FILE EXCEL YANG LAMA DIBUKA

Do you ever experience working on an Excel file and suddenly it won’t save or won’t open? Don’t worry, you’re not alone. Below are some common Excel file issues and their solutions.

1. Cara Mengembalikan File Excel Yang Belum Tersimpan

CARA MENGATASI FILE EXCEL YANG LAMA DIBUKA

Have you ever worked on an Excel file for hours, only to realize that you haven’t saved it yet? It can be frustrating, but there is a way to recover your unsaved work.

The first way to recover your unsaved Excel file is to check the AutoRecover folder. By default, Excel saves a copy of your unsaved work every 10 minutes. To check the AutoRecover folder, follow these steps:

  1. Open Excel and click on “File”.
  2. Click on “Info”.
  3. Click on “Manage Workbook” and select “Recover Unsaved Workbooks”.
  4. Look for the specific file you want to recover and click “Open”.
  5. Save the file to your desired location.

If the AutoRecover option doesn’t work, you can also try to recover the file through temporary files. Follow these steps:

  1. Open Excel and create a new file.
  2. Click on “File” and select “Options”.
  3. Click on “Save”.
  4. Look for the “AutoRecover file location” and remember the path.
  5. Go to the Windows File Explorer and enter the path.
  6. Look for files that start with “~$”.
  7. Find the specific file you want to recover and change the extension from .tmp to .xlsx.
  8. Open the file in Excel and save it to your desired location.
Baca Juga :  Cara Membuat Rumus Untuk Mengurutkan Angka Di Excel

By following these steps, you can easily recover your unsaved Excel file.

2. Cara Akses File Excel yang Tidak Bisa Diedit

Cara Akses File Excel yang Tidak Bisa Diedit

Do you encounter an Excel file that you can’t edit or modify? This issue usually happens when the file is set to read-only, but there are also other reasons why the file becomes uneditable.

The first thing to do is to check the file properties and ensure that it’s not set to read-only. Follow these steps:

  1. Right-click on the Excel file and select “Properties”.
  2. Uncheck the “Read-only” option if it’s selected.
  3. Click “Apply” and “OK”.

If the read-only option is unchecked, but you still can’t edit the file, you can try to check the file permissions. Follow these steps:

  1. Right-click on the Excel file and select “Properties”.
  2. Go to the “Security” tab.
  3. Click on “Edit” and check if your user account has the necessary permissions.
  4. If not, click on “Add” and add your user account.
  5. Check the “Full Control” box.
  6. Click “Apply” and “OK”.

If these steps still don’t work, try to copy the content of the uneditable Excel file and paste it into a new workbook. This should resolve any corruption issues with the original file and make it editable again.

Frequently Asked Questions

1. Can I recover an Excel file if I accidentally deleted it?

Yes, you can recover a deleted Excel file if you acted quickly. First, check the Recycle Bin on your computer and see if the file is still there. If not, you can try to recover the file using file recovery software like Recuva.

Baca Juga :  CARA MEMBUAT TULISAN MIRING KE ATAS DI EXCEL

2. How do I remove a password from an Excel file?

If you’ve forgotten the password to your Excel file, you can remove it using VBA code. Follow these steps:

  1. Open the password-protected Excel file.
  2. Press “Alt” + “F11” to open the VBA editor.
  3. Go to “Insert” and select “Module”.
  4. Paste the following code:
  5. Sub PasswordBreaker()
        Dim i As Integer, j As Integer, k As Integer
        Dim l As Integer, m As Integer, n As Integer
        Dim i1 As Integer, i2 As Integer, i3 As Integer
        Dim i4 As Integer, i5 As Integer, i6 As Integer
        On Error Resume Next
        For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
        For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
        For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
        For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
        ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
            Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
            Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
        If ActiveSheet.ProtectContents = False Then
            MsgBox "One usable password is " & Chr(i) & Chr(j) & _
                Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
                Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
             Exit Sub
        End If
        Next: Next: Next: Next: Next: Next
        Next: Next: Next: Next: Next: Next
    End Sub
  6. Press “F5” or “Run” to execute the code.
  7. A pop-up box will appear that shows the password of the worksheet.
  8. Enter the password to unlock the worksheet.
  9. Go to “File” and select “Save As”.
  10. Select “Excel Workbook” from the “Save as type” dropdown.
  11. Save the file to a new location and it will no longer have a password.
Baca Juga :  Cara Menghitung Pertambahan Dalam Excel