Ungalilungisa Kanjani Ifayela le-Excel Elonakele noma Elimele

Uma amafayela e-Microsoft Excel (.xls, .xlw, .xlsx) onakele noma onakele futhi engakwazi ukuvulwa, landela lezi zinyathelo ukuze ulungise ifayela:

Qaphela: Ngaphambi kuka-starukulinganisa inqubo yokutholwa kwedatha, dala ikhophi yasenqolobaneni yefayela lokuqala elonakele le-Excel.

  1. I-Microsoft Excel inomsebenzi wokulungisa owakhelwe ngaphakathi. Uma ithola ukuthi ifayela lakho le-Excel lonakele, izozama ukulungisa ifayela lakho. Kwezinye izimo, uma umsebenzi ungeyena u-started ngokuzenzakalelayo, ungaphoqa i-Excel ukuthi ilungise ifayela lakho mathupha. Thatha i-Excel 2013 njengesibonelo, izinyathelo yilezi:
    1. Chofoza Vula ku Ifayela imenyu.
    2. Ku-Vula ibhokisi lengxoxo, khetha ifayela, bese uchofoza umcibisholo oseceleni kwe Vula inkinobho.
    3. Khetha Vula futhi Lungisa, bese ukhetha indlela yokutakula yebhuku lakho lokusebenza.
    4. Khetha Ukulungisa kuya hlenga inani eliphezulu ledatha kusuka ifayela elikhohlakele.
    5. If Ukulungisa ehluleka, sebenzisa Khipha idatha ukubuyisa idatha yeselula namafomula.

    Izinqubo zokubuyisela zingahluka kancane phakathi kwezinguqulo ze-Excel.

  2. Ukuhlolwa kwethu kwembula ukuthi indlela 1 isebenza ngokuyinhloko lapho ukonakala kwefayela kwenzeka ekupheleni kwefayela. Kodwa kuvame ukwehluleka uma ukonakala kwenzeka kunhlokweni noma ezigabeni ezimaphakathi zefayela.
  3. Uma indlela yoku-1 yehluleka, zama izindlela zokulungisa ezengeziwe ngesandla nge-Excel, njengokubhala i-VBA macro encane. Ulwazi olwengeziwe lungatholakala ekhasini losekelo le-Microsoft: https://support.microsoft.com/en-gb/office/repair-a-corrupted-workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53
  4. Amanye amathuluzi amahhala ezinkampani zangaphandle angavula futhi afunde amafayela onakele e-Excel, okuhlanganisa I-OpenOffice, I-LibreOffice, I-KingSoft Spreadsheets, Futhi AmaSpredishithi e-Google. Uma elinye lalawa mathuluzi lingavula ifayela lakho ngempumelelo, lilondoloze njengefayela elisha elingenaphutha.
  5. amafayela we-xlsx empeleni acindezelwe Zip amafayela. Ngakho-ke, ngezinye izikhathi, uma inkohlakalo ibangelwa kuphela Zip ifayela, zama ukusebenzisa i-a Zip ukulungisa ithuluzi ezifana DataNumen Zip Repair:
    1. Qamba kabusha ifayela le-Excel elonakele (isb, ukusuka ku-myfile.xlsx kuya ku-myfile.zip).
    2. Sebenzisa DataNumen Zip Repair ukulungisa myfile.zip futhi ukhiqize i-myfile_fixed.zip.
    3. Qamba kabusha i-myfile_fixed.zip buyela ku-myfile_fixed.xlsx.
    4. Vula myfile_fixed.xlsx ku-Excel.

    Lapho uvula ifayela elilungisiwe ku-Excel, usengahlangabezana nezixwayiso ezimbalwa. Ungawanaki, futhi i-Excel izozama ukuvula nokulungisa ifayela. Uma ifayela livuleka ngempumelelo, gcina okuqukethwe kwalo efayelini elisha elingenaphutha.

  6. Uma zonke izindlela ezingenhla zihluleka, sebenzisa DataNumen Excel Repair ukuxazulula udaba. Izoskena ifayela eyonakele futhi ikhiqize ifayela elisha elingenaphutha ngokuzenzakalelayo.