Yadda Ake Gyara Fassara Fayil na Excel

Lokacin da fayilolin Microsoft Excel (.xls, .xlw, .xlsx) suka lalace ko kuma ba za a iya buɗe su ba, bi waɗannan matakan don gyara fayil ɗin:

lura: Kafin startsarin dawo da data, ƙirƙira maajiyar asalin gurbataccen fayil ɗin Excel.

1. Microsoft Excel yana da ginanniyar aikin gyarawa. Lokacin da ta ga fayil ɗin Excel ɗin ku ya lalace, zai yi ƙoƙarin gyara fayil ɗin ku. A wasu lokuta, idan aikin ba started ta atomatik, zaku iya tilasta Excel don gyara fayil ɗin ku da hannu. Dauki Excel 2013 a matsayin misali, matakan sune:
   1. Click Bude a cikin fayil menu.
   2. A cikin Buɗe akwatin maganganu, zaɓi fayil ɗin, sannan danna kibiya kusa da Bude button.
   3. Select Bude da Gyara, sannan zaɓi hanyar dawowa don littafin aikin ku.
   4. Select gyara to ceto matsakaicin adadin bayanai daga gurbatattun fayil.
   5. If gyara kasa, amfani Cire bayanai don dawo da bayanan tantanin halitta da dabaru.

   Hanyoyin farfadowa na iya bambanta dan kadan tsakanin nau'ikan Excel.

2. Gwajin mu yana nuna cewa hanyar 1 tana aiki galibi lokacin da lalata fayil ya faru a ƙarshen fayil ɗin. Amma yana ƙoƙarin gazawa idan cin hanci da rashawa ya faru a cikin taken ko tsakiyar sassan fayil ɗin.
3. Idan hanyar 1 ta gaza, gwada ƙarin dabarun gyaran hannu tare da Excel, kamar rubuta ƙaramin VBA macro. Ana iya samun ƙarin bayani akan shafin tallafi na Microsoft: https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
4. Wasu kayan aikin ɓangare na uku na kyauta kuma za su iya buɗewa da karanta fayilolin Excel marasa kyau, gami da OpenOffice, LibreOffice, KingSoft Spreadsheets, Da kuma Google Sheets. Idan ɗayan waɗannan kayan aikin na iya buɗe fayil ɗinku cikin nasara, adana shi azaman sabon fayil mara kuskure.
5. xlsx fayiloli a zahiri suna matsawa Zip fayiloli. Saboda haka, wani lokacin, idan cin hanci da rashawa ne kawai ya haifar da Zip fayil, gwada amfani da a Zip kayan aikin gyara kamar DataNumen Zip Repair:
   1. Sake suna ga gurbatattun fayil ɗin Excel (misali, daga myfile.xlsx zuwa myfile.zip).
   2. amfani DataNumen Zip Repair don gyara myfile.zip kuma samar da myfile_fixed.zip.
   3. Sake suna myfile_fixed.zip Komawa zuwa myfile_fixed.xlsx.
   4. Bude myfile_fixed.xlsx a cikin Excel.

   Bayan buɗe fayil ɗin da aka gyara a cikin Excel, har yanzu kuna iya fuskantar wasu gargaɗi kaɗan. Yi watsi da su, kuma Excel zai yi ƙoƙarin buɗewa da gyara fayil ɗin. Idan fayil ɗin ya buɗe cikin nasara, adana abun ciki zuwa sabon fayil mara kuskure.

6. Idan duk hanyoyin da ke sama sun gaza, yi amfani da su DataNumen Excel Repair don warware matsalar. Zai bincika fayil ɗin da ya lalace kuma ya haifar da sabon fayil mara kuskure ta atomatik.