Momwe Mungakonzere Fayilo Yowonongeka kapena Yowonongeka

Maofesi anu a Microsoft Excel .xls, .xlw ndi .xlsx awonongeka kapena atayipitsidwa chifukwa cha zifukwa zosiyanasiyana ndipo simungathe kuwatsegula bwino ndi Excel, mutha kugwiritsa ntchito njira zotsatirazi kuti mukonze fayilo yoipayo:

Zindikirani: Pamaso pa starTing ndi njira yobwezeretsera deta, muyenera kutero pangani zosunga zobwezeretsera fayilo yanu yoyipa ya Excel. Uyu ndiye most sitepe yofunika yomwe ambiri amaiwala.

  1. Choyamba, Microsoft Excel ili ndi ntchito yokonzanso. Ikazindikira kuti pali ziphuphu mu fayilo yanu ya Excel, izikhala start Kubwezeretsa Fayilo mode ndi kuyesa kukonza wapamwamba kwa inu. Nthawi zina, ngati Kubwezeretsa Fayilo mawonekedwe si start zokha, ndiye kuti mutha kukakamiza Excel kuti ikonze fayilo yanu pamanja. Tengani Excel 2013 monga chitsanzo, njira zake ndi izi:
    1. pa file menyu Dinani Open.
    2. Mubokosi la Open dialog, sankhani fayilo yomwe mukufuna kutsegula, ndikudina miviyo pafupi ndi Open batani.
    3. Dinani Tsegulani ndi Kukonza, kenako sankhani njira yomwe mukufuna kugwiritsa ntchito kuti mupezenso buku lanu la ntchito.
    4. Sankhani kukonza mwina ngati mukufuna kupeza zambiri monga momwe zingathere kuchokera pa fayilo yachinyengo.
    5. If kukonza sagwira ntchito, ndiye gwiritsani ntchito Pezani Zambiri kuti ayesere kutulutsa mawonekedwe am'manja ndi mayendedwe ake mu fayilo.

    Njira zochotsera ndizosiyana pang'ono pamitundu yosiyanasiyana ya Excel.

    Kutengera kuyesa kwathu, njira 1 imagwira ntchito makamaka pamilandu yomwe ziphuphu zimachitika mchira wa fayilo. Koma sizigwira ntchito ziphuphu zikafika pamutu kapena pakati pa fayilo.

  2. Ngati njira 1 yalephera, pali njira zingapo zokonzera fayilo yanu ya Excel pamanja ndi Excel, kuphatikiza kulemba pang'ono VBA macro, mutha kupeza zambiri https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
  3. Palinso zida zaulere kuchokera kwa anthu ena zomwe zingatsegule ndikuwerenga mafayilo a Microsoft Excel, mwachitsanzo,

    Nthawi zina pamene Excel yalephera kutsegula fayilo yanu, zida izi zimatha kutsegula bwino. Ngati ndi choncho, ndiye kuti fayilo ya Excel itatsegulidwa, mutha kungoisunga ngati fayilo yatsopano yomwe idzakhala yopanda zolakwika.

  4. Kwa mafayilo a xlsx, alidi gulu la mafayilo opanikizidwa Zip mtundu wa fayilo. Chifukwa chake, nthawi zina, ngati ziphuphu zimangobwera chifukwa cha Zip file, ndiye mutha kugwiritsa ntchito Zip kukonza zida monga DataNumen Zip Repair kuti akonze fayilo, motere:
    1. Poganiza kuti fayilo yoipa ya Excel ndi a.xlsx, ndiye muyenera kuyisinthanso kukhala.zip
    2. kugwiritsa DataNumen Zip Repair kukonza a.zip ndikupanga fayilo yokhazikika a_fixed.zip.
    3. Sinthani dzina a_fixed.zip kubwerera ku a_fixed.xlsx
    4. Pogwiritsa ntchito Excel kutsegula a_ixed.xlsx.

    Pakhoza kukhala machenjezo ena mukatsegula fayilo yokhazikika mu Excel, ingonyalanyazani ndipo Excel ayesa kutsegula ndikukonzekera fayilo yomwe yakhazikitsidwa. Ngati fayilo ikhoza kutsegulidwa bwino, ndiye kuti mutha kungosunga zomwe zili mu fayilo ina yopanda zolakwika.

  5. Ngati njira zonse pamwambazi zalephera, ndiye kuti muyenera kugwiritsa ntchito DataNumen Excel Repair kuthetsa vutoli. Iwona mafayilo oyipitsidwa ndikupanga fayilo yatsopano yopanda zolakwika.