BAGAIMANA CARA MEMBUKA FILE DI EXCEL 2010 DARI ONEDRIVE

Do you often use Excel 2010 and have trouble opening files from OneDrive? In this article, we will provide you with the steps you need to take in order to open your Excel files from OneDrive easily.

Cara Membuka File Di Excel 2010 Dari Onedrive

If you’re having trouble opening your Excel files from OneDrive in Excel 2010, here are some steps you can follow:

  1. Open your Excel application and click on the “File” tab in the top-left corner.
  2. Click on “Open”.
  3. Under “Places”, click on “OneDrive”.
  4. Click on your desired file to open it.

Alternatively, you can open the file by double-clicking it on your OneDrive folder in your computer.

Cara Membuka File Excel yang Terkunci Tanpa Aplikasi

If you have an Excel file that is password-protected and you can’t seem to open it, don’t worry, there’s an easy way to unlock it without needing any additional software. Here are the steps you need to follow:

  1. Open your Excel application and click on the “File” tab in the top-left corner.
  2. Click on “Open”.
  3. Click on your password-protected file to select it.
  4. Click on the “Open” button, but do not enter your password yet.
  5. Press “ALT + F11” to open the VBA editor.
  6. Click on “Insert” and then select “Module”.
  7. Copy and paste the following code into the module:
  8. Sub PasswordBreaker()
    'Breaks worksheet password protection.
    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) & i1 & i2 & i3 & i4 & i5 & i6 & Chr(n)
    If ActiveSheet.ProtectContents = False Then
    MsgBox "Password is " & Chr(i) & Chr(j) & _
    Chr(k) & Chr(l) & Chr(m) & i1 & i2 & i3 & i4 & i5 & i6 & Chr(n)
    Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
    End Sub

  9. Click on the “Run” button to run the code.
  10. Enter the password of your file when prompted.
  11. Close the VBA editor and you should now be able to edit your file without the need for a password.
Baca Juga :  CARA EXCEL MEMILIH DATA YANG BELUM TRANSAKSI

Cara Merubah atau Membuka File CSV Di Excel

CSV files can sometimes be a bit tricky to work with in Excel, but don’t worry, we’ll show you how to easily open and work with them in Excel. Here are the steps you need to follow:

  1. Open your Excel application and click on the “Data” tab.
  2. Click on “From Text/CSV”.
  3. Find and select your CSV file and click on “Import”.
  4. Follow the import wizard to set your delimiter and formatting options.
  5. Once done, click on “Finish” to import your CSV file into Excel.

FAQ

What if I don’t have Excel 2010?

If you don’t have Excel 2010, don’t worry, you can still follow the same steps to open your files from OneDrive. Just make sure you have the correct version of Excel and you should be good to go.

Can I change the delimiter of my CSV file?

Yes, you can. When you’re importing your CSV file into Excel, you can set your own delimiter in the import wizard. Just make sure to select the correct delimiter so that your data is properly formatted.

Video Tutorial