Gejala:
Nalika mbukak file Excel XLSX sing rusak utawa rusak nganggo Microsoft Excel, sampeyan bakal weruh pesen kesalahan ing ngisor iki:
Excel nemokake konten sing ora bisa diwaca ing . Apa sampeyan pengin mbalekake isi buku kerja iki? Yen sampeyan percaya sumber buku kerja iki, klik Ya.
ngendi filename.xlsx iku jeneng file Excel rusak utawa rusak.
Ing ngisor iki minangka conto gambar pesen kesalahan:
Yen sampeyan milih "Ya", banjur Excel bakal nyoba ndandani file Excel sing rusak. Ana rong kahanan, kaya ing ngisor iki:
1. Excel ora bisa ndandani file.
Ing kasus kasebut, bakal nampilake pesen kesalahan ing ngisor iki:
Excel ora bisa mbukak file 'filename.xlsx' amarga format file utawa ekstensi file ora valid. Priksa manawa file kasebut ora rusak lan ekstensi file cocog karo format file kasebut.
ngendi filename.xlsx iku jeneng file Excel rusak utawa rusak.
Ing ngisor iki minangka gambar saka pesen kesalahan:
2. Excel bisa ndandani file.
Ing kasus kasebut, bakal nampilake pesen ing ngisor iki:
Excel bisa mbukak file kanthi ndandani utawa mbusak konten sing ora bisa diwaca.
karo isi sing didandani utawa dibusak kapacak ing ngisor iki pesen.
Ing ngisor iki minangka conto gambar pesen kasebut:
Sawise sampeyan ngeklik tombol "Tutup", Excel bakal mbukak file tetep. Ana rong kahanan:
Sawetara data mbalekake ing file tetep, nanging akèh data sing lost sawise Diposaken / proses Recovery.
Ora ana data nyata ing file tetep sawise proses ndandani / Recovery.
Nalika mbukak file Excel XLS sing rusak utawa rusak karo Microsoft Excel, sampeyan uga bakal weruh pesen kesalahan sing padha:
Dokumen kasebut rusak lan ora bisa dibukak. Kanggo nyoba lan ndandani, gunakake perintah Bukak lan Repair ing kothak dialog Bukak, banjur pilih Ekstrak Data yen dijaluk.
Ing ngisor iki minangka conto gambar pesen kesalahan:
Yen sampeyan milih "OK", banjur Excel bakal nyoba ndandani file Excel sing rusak lan nampilake pesen ing ngisor iki:
Kesalahan dideteksi ing 'filename.xls,' nanging Microsoft Office Excel bisa mbukak file kasebut kanthi ndandani ing ngisor iki. Simpen file supaya ndandani iki permanen.
ngendi filename.xls file XLS ngrusak lagi didandani.
Lan asil ndandani bakal kapacak ing ngisor pesen.
Ing ngisor iki minangka conto gambar pesen kasebut:
Sawise sampeyan ngeklik tombol "Tutup", Excel bakal mbukak file tetep. Nanging, akeh data sing lost sawise Diposaken / proses Recovery.
Panjelasan sing tepat:
Nalika file Excel sampeyan rusak lan sawetara bagean ora bisa dingerteni dening Excel, banjur Excel bakal nglaporake pesen kesalahan iki lan nyoba ndandani. Nanging, amarga kemampuan Recovery watesan Excel, sawise proses repair / Recovery, ora data nyata bakal mbalekake utawa akeh data bakal l.ost.
Solution:
Sampeyan bisa nggunakake DataNumen Excel Repair kanggo mbalekake file Excel sing rusak, sing bakal mbalekake data luwih akeh tinimbang Excel.
Contoh File 1:
File XLS sing rusak: Error4.xlsx
Kanthi fungsi ndandani sing dibangun ing Excel, Excel gagal ndandani file kasebut.
kanthi DataNumen Excel Repair: 100% data bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error4_fixed.xls
Contoh File 2:
File XLS sing rusak: Error3_1.xlsx
Kanthi fungsi perbaikan sing dibangun ing Excel, 0% data sel bisa mbalekake.
kanthi DataNumen Excel Repair: 61% data bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error3_1_fixed.xls
Contoh File 3:
File XLS sing rusak: Error3_2.xlsx
Kanthi fungsi perbaikan sing dibangun ing Excel, 0% data sel bisa mbalekake.
kanthi DataNumen Excel Repair: 36% data bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error3_2_fixed.xls
Contoh File 4:
File XLS sing rusak: Error3_4.xlsx
Kanthi fungsi perbaikan sing dibangun ing Excel, 0% data sel bisa mbalekake.
kanthi DataNumen Excel Repair: 16.7% data bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error3_4_fixed.xls
Contoh File 5:
File XLS sing rusak: Error3_5.xlsx
Kanthi fungsi perbaikan sing dibangun ing Excel, 0% data sel bisa mbalekake.
kanthi DataNumen Excel Repair: 95% data bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error3_5_fixed.xls
Contoh File 6:
File XLS sing rusak: Error3_7.xlsx
Kanthi fungsi perbaikan sing dibangun ing Excel, 0% data sel bisa mbalekake.
kanthi DataNumen Excel Repair: 5% data bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error3_7_fixed.xls
Contoh File 7:
File XLSX sing rusak: Error2_1.xlsx
Kanthi fungsi perbaikan sing dibangun ing Excel, 50% data sel bisa mbalekake.
kanthi DataNumen Excel Repair: 89% data sel bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error2_1_fixed.xls
Contoh File 8:
File XLS sing rusak: Error2_2.xls
Kanthi fungsi perbaikan sing dibangun ing Excel, 50% data sel bisa mbalekake.
kanthi DataNumen Excel Repair: 100% data bisa mbalekake.
File didandani dening DataNumen Excel Repair: Error2_2_fixed.xlsx