Mokhoa oa ho lokisa file e senyehileng kapa e senyehileng ea Excel

Ha lifaele tsa hau tsa Microsoft Excel .xls, .xlw le .xlsx li senyehile kapa li senyehile ka lebaka la mabaka a fapaneng mme o sitoa ho li bula ka katleho ka Excel, o ka sebelisa mehato e latelang ho lokisa faele e senyehileng:

Hlokomela: Pele ho starTsamaiso ea ho hlaphoheloa ha data, o hloka ho etsa backup ea file ea hau ea pele e senyehileng ea Excel. Ena ke most mohato oa bohlokoa oo ba bangata ba tla lebala.

  1. Pele ho tsohle, Microsoft Excel e na le ts'ebetso ea ho lokisa e hahelletsoeng. Ha e fumana hore ho na le bobolu faeleng ea hau ea Excel, e tla start Fumana Pholoso 'me u leke ho u lokisetsa file. Maemong a mang, haeba Fumana Pholoso mode ha se start ka boiketsetso, o ka qobella Excel ho lokisa faele ea hau ka letsoho. Nka Excel 2013 e le mohlala, mehato ke:
    1. Ka faele menu ya, tobetsa Open.
    2. Ka lebokoseng la Open dialog, khetha faele eo u batlang ho e bula, ebe u tobetsa motsu haufi le Open konopo.
    3. Click Bula le ho lokisa, 'me u khethe mokhoa oo u batlang ho o sebelisa ho khutlisa buka ea hau ea mosebetsi.
    4. khetha Repair khetho haeba o batla ho fumana lintlha tse ngata kamoo ho ka khonehang ho tsoa faeleng e senyehileng.
    5. If Repair ha e sebetse, ebe sebelisa Tlosetsa Boitsebiso ho leka ho ntša litekanyetso tsa lisele le litlhaloso ho file.

    Mekhoa ea ho hlaphoheloa e fapane hanyane bakeng sa mefuta e fapaneng ea Excel.

    Ho ipapisitsoe le teko ea rona, mokhoa 1 o sebetsa haholo bakeng sa linyeoe ha bobolu bo hlaha mohatleng oa faele. Empa e ke ke ea sebetsa ha bobolu bo hlaha hloohong kapa bohareng ba faele.

  2. Haeba mokhoa oa 1 o hloleha, ho ntse ho na le mekhoa e 'maloa ea ho lokisa faele ea hau ea Excel ka letsoho le Excel, ho kenyelletsa ho ngola VBA macro e nyane, o ka fumana tlhaiso-leseling e batsi ho https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
  3. Hape ho na le lisebelisoa tsa mahala tse tsoang ho batho ba boraro tse ka bulang le ho bala lifaele tsa Microsoft Excel, mohlala,

    Ka linako tse ling ha Excel e hloleha ho bula file ea hau, lisebelisoa tsena li ka khona ho e bula ka katleho. Haeba ho le joalo, kamora hore faele ea Excel e buloe, o ka e boloka e le faele e ncha e ke keng ea ba le liphoso.

  4. Bakeng sa lifaele tsa xlsx, ehlile ke sehlopha sa lifaele tse hatelletsoeng ho Zip fomate ea faele. Ka hona, ka linako tse ling, haeba bobolu bo bakoa feela ke Zip file, u ka sebelisa Zip Lisebelisoa tsa ho lokisa joalo ka DataNumen Zip Repair ho lokisa faele ka tsela e latelang:
    1. Ho nka hore faele e senyehileng ea Excel ke a.xlsx, ebe o hloka ho e reha lebitso la.zip
    2. U sebelisa DataNumen Zip Repair ho lokisa a.zip mme ra hlahisa faele e tsitsitseng a_fixed.zip.
    3. Reha lebitso la a_fixed.zip khutlela ho a_fixed.xlsx
    4. U sebelisa Excel ho bula a_fixed.xlsx.

    Ho kanna ha ba le litemoso ha o bula file e tsitsitseng ho Excel, e tlohele feela e e hlokomolohe mme Excel e tla leka ho bula le ho lokisa file e tsitsitseng. Haeba faele e ka buloa ka katleho, u ka boloka litaba tse ka hare ho file e 'ngoe e se nang liphoso.

  5. Haeba mekhoa eohle e kaholimo e hloleha, o tla hloka ho e sebelisa DataNumen Excel Repair ho rarolla bothata. E tla sekaseka faele e senyehileng ebe e u hlahisetsa faele e ncha e se nang liphoso.