Yadda Ake Gyara Fassara Fayil na Excel

Lokacin da fayilolin Microsoft .xls, .xlw da .xlsx suka lalace ko suka lalace saboda wasu dalilai kuma baza ku iya bude su cikin nasara ba tare da Excel, zaku iya amfani da wadannan matakan don gyara fayil din da ya lalace:

lura: Kafin starTing tsarin dawo da bayanai, kuna buƙatar yi ajiyar ajiyar fayil ɗinku na asali mai lalata. Wannan shine most muhimmin mataki wanda da yawa zasu manta dashi.

  1. Da farko dai, Microsoft Excel na da aikin gyara a ciki. Lokacin da ta gano akwai ɓarna a cikin fayil ɗinku na Excel, zai start Mayar da fayil Yanayin kuma gwada gyara fayil ɗin a gare ku. A wasu lokuta, idan Mayar da fayil yanayin ba start ta atomatik, to zaka iya tilasta Excel gyara fayil ɗinka da hannu. Excelauki Excel 2013 a matsayin misali, matakan sune:
    1. a fayil menu, danna Open.
    2. A cikin Open maganganun akwatin, zaɓi fayil ɗin da kake son buɗewa, ka danna kibiya kusa da Open button.
    3. Click Bude da Gyara, sannan ka zabi wacce hanya kake son amfani da ita domin dawo da littafin aiki.
    4. zabi gyara zaɓi idan kuna son dawo da bayanai mai yawa kamar yadda zai yiwu daga fayil ɗin mai lalata.
    5. If gyara ba ya aiki, to amfani Cire bayanai don ƙoƙarin cire ƙimomin tantanin halitta da tsari daga fayil ɗin.

    Hanyoyin dawo da su ba su da bambanci daban-daban na nau'ikan Excel.

    Dangane da gwajinmu, hanyar 1 ta fi dacewa don shari'o'in lokacin da ɓarna ta faru a wutsiyar fayil ɗin. Amma ba zai yi aiki ba lokacin da lalata ta faru a cikin taken kai tsaye ko tsakiyar fayil ɗin.

  2. Idan hanya ta 1 ta gaza, akwai sauran hanyoyi da yawa don gyara fayil ɗinku na Excel da hannu tare da Excel, gami da rubuta ƙaramin VBA macro, zaku iya samun cikakken bayani a https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
  3. Hakanan akwai kayan aikin kyauta daga wasu kamfanoni waɗanda zasu iya buɗewa da karanta fayilolin Microsoft Excel, misali,

    Wani lokaci idan Excel ya kasa buɗe fayil ɗin ka, waɗannan kayan aikin na iya buɗe shi cikin nasara. Idan haka ne, to bayan an buɗe fayil ɗin Excel, za ku iya kawai adana shi azaman sabon fayil wanda zai zama ba mai kuskure ba.

  4. Don fayilolin xlsx, a zahiri rukuni ne na fayilolin da aka matse a ciki Zip tsarin fayil. Saboda haka, wani lokacin, idan lalacewar kawai ta hanyar Zip fayil, to, zaku iya amfani Zip kayan gyara kamar DataNumen Zip Repair don gyara fayil ɗin, kamar haka:
    1. Fahimtar cewa ɓataccen fayil na Excel a.xlsx ne, to kuna buƙatar sake suna zuwa wani.zip
    2. Amfani DataNumen Zip Repair gyara a.zip da ƙirƙirar tsayayyen fayil a_fixed.zip.
    3. Sake suna a_fixed.zip koma zuwa_fixed.xlsx
    4. Amfani da Excel don buɗe a_fixed.xlsx.

    Har yanzu ana iya samun wasu faɗakarwa yayin buɗe fayil ɗin da aka gyara a cikin Excel, kawai bari a kyale shi kuma Excel zai yi ƙoƙarin buɗewa da gyara tsayayyen fayil Idan ana iya buɗe fayil ɗin cikin nasara, to kawai za ku iya adana abubuwan cikin cikin wani fayil ɗin da babu kuskure.

  5. Idan duk hanyoyin da ke sama sun kasa, to kana buƙatar amfani DataNumen Excel Repair don magance matsalar. Zai bincika fayil ɗin da aka lalata kuma ya samar muku da sabon fayil wanda ba shi da kuskure.